Forum Discussion
Solved
Using lookupvalue for hierarchy filter
Hello, I'm using the following column formula to return my hiearchy filter CHANNEL NAME = lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C]) It works, but...
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,
Show the expected result in another worksheet of the Excel workbook.
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.