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.

     

o59393's avatar
o59393
Post Prodigy
6 years ago

Haha sorry, you are right.

 

Hmm, can it be done with a dax instead of power query?

 

Thanks Ashish!

 

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.