Forum Discussion
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 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!
20 Replies
Please refer to this blog how work with two date, if this can help
Appreciate your Kudos.
Hi amitchandak
I see you use count x, but in my case is not a count of cases. Is pretty much return a value based on the date ranges.
Appreciate you help!
o59393 , Use this file. It has allocation between dates. You just do a copy no allocation
You just did a
Weight New = SUM(test1[Weight]) * 10How did that take the right dates and why by 10?ThanksHi,
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.
