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,
I do not see a second tab in that workbook. In that new tab, please also explain how you got the result.
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