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,

You may download my PBI file from here.

Hope this helps.

 

o59393's avatar
o59393
Post Prodigy
6 years ago

Hi Ashish_Mathur 

 

You just did a 

 

Weight New = SUM(test1[Weight]) * 10
 
How did that take the right dates and why by 10?
 
Thanks

 

  • 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?