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
Hi Ashish_Mathur I added another tab with the desired outcome. I'm wanting to show these days difference average in scorecards within PBI with their respective headers. Below is the screenshot of the new tab i created.
Hi,
I do not see a second tab in that workbook. In that new tab, please also explain how you got the result.
The stage flows i'm looking for are when an oldvalue goes from Assigned to newvalue working, oldvalue working to newvalue won, and oldvalue working to newvalue returned (i've already aggrated the stages that need to be considered returned). You'll notice that the oldvaluecreatedate will, for the most part, always be an earlier time stamp when compared to the newvaluecreatedate. So i'm trying to get the days difference between those createdate columns, based on the oldvalue/newvalue stage outcomes i laid out above.
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