Hi everybody,
I’m a newbie to DAX,
I`m trying to add a column with the person who has the requisiton at a given time, for example,
if a purchase requisition has a review, draft, canceled or approved status, I wan to show in a new column on the same grid the name of the person (worker) that has in that moment the Purchase Requisition. Please take a look at attached image 1.
Now, you can view the name of the person 2 ways:
1.- Please check attached Image2, here on the same screen as the grid, to the right side, if I select Purchase Requisition 000881 on the grid, the Review Process Details section shows the name of the person that currently has the PR.
2.- While Purchase Requisition 000881 still selected, the second way is to click the button above the grid Actions-> View History, then I’m taken to the following screen, at the bottom in the (Tracking Details tab) tabs section to the right after selecting the appropiate tree ítems, I get a box with the name of the person that currently has the PR and a due date, again this is the name I ant to display on the grid. Please check attached Image3.
Hope I was able to explain what I want to achive, please your urgent help is greately appreciated.
Best Regards
Verci