Nested IF DAX

[o59393]

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 right table you will see product1 has 3 rows. The weight differs based on the start and end date.

How can I get a dax metric that returns me correct weight for each day? In the left table you will see a bunch of 0.10, instead of this I would like to have the 0.07, 0 or 0.03

I attach the pbix

https://1drv.ms/u/s!ApgeWwGTKtFdhjRSVqf-G5rb4BdX?e=n7kuj4

Thanks all!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.