Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Nested IF DAX

Hi all   I need to have an if formula that returns me a value from one column (Weight in this case) based on the date ranges (start date and end date).     In the example above, on the rig...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Why would you need that.  What is the problem with the solution i have shared with you?

 

o59393's avatar
o59393
Post Prodigy
6 years ago

No problem at all, I would just like to see how that's done with dax if possible.

 

Thanks Ashish_Mathur !

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You are welcome.  if my reply helped, please mark it as Answer.

     

    • o59393's avatar
      o59393
      Post Prodigy
      6 years ago

      Hi Ashish_Mathur 

       

      I tested the solution on the pbix but it's not working well, the thing is that I have more than one weight attribute.

       

      The columns are ingredients from a bill of materials.

       

       

      Maybe the power query is not the best option or i am doing it wrong

       

      Let me send another pbix with more realistic data. 

       

      Thanks. 

       

      • o59393's avatar
        o59393
        Post Prodigy
        6 years ago

        Hi Ashish_Mathur 

         

        I attach my PBIx using (or trying to use) your steps. In the table dashboard, you will see It is repeating each of the days 3 times.

         

        Also I noticed you removed the end and start date from the query, I need those dates to be visible in my dahsboard for people to see it.

         

        Can you help me?

         

        https://1drv.ms/u/s!ApgeWwGTKtFdhjb-8R5LAVb1Amnk

         

        Thanks