Forum Discussion

Antonio195754's avatar
Antonio195754
Helper IV
3 years ago
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...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

  • Antonio195754's avatar
    Antonio195754
    3 years ago

    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 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

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.

  • Antonio195754's avatar
    Antonio195754
    Helper IV
    3 years ago

    That worked perfectly, thank you!!!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      You are welcome.

      • Antonio195754's avatar
        Antonio195754
        Helper IV
        3 years ago

        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.