Forum Discussion
Using lookupvalue for hierarchy filter
Hi,
Try this
=if(isblank(lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C])),"XYZ",lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C]))
Hope this helps.
Figured out how to tackle this one. I just filtered the given outcome i needed to see with a measure, and date a date difference of greater than 0 and put it in a scorecard. Thanks for the help! Ashish_Mathur
Could you please help with this DAX...
I'm wanting to find the date difference where i have a date column and another column that tells me a stage a given sale is in. STAGE column includes stage "Assigned", "Working", "Won", "Rejected". And the CREATEDATE are the dates from one stage to another.
What i'm trying to do is provide how many days average it takes to move from one stage to another. Could you please help with that? I can create a new message as well, but i wanted to reach out to you.
Ashish_Mathur also the order i provided is the sequence the stages should be in. So how long it takes from assigned to working, from working to won, and won to rejected.