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

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.