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

Hi,

I did not write that measure.  It was already there in your file.  I carried out transformation steps on the second table to create one row for each date.

 

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.