Forum Discussion
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...
Apologies for the confusion.
Here is the excel with the desired solution. You will see colors blue, green and yellow that distinguish the values based on the dates.
https://1drv.ms/x/s!ApgeWwGTKtFdhjcOMqI6H9v620Lg?e=sAOzy5
Please do not remove the original columns start and end date with Power Query,
Hope this clarifies.
Regards.
You have shared the expected result. Now share the original data also in an Excel file.
Here you go
https://1drv.ms/u/s!ApgeWwGTKtFdhjucn0A8Q0gRN9jv?e=mhuaxU
Appreciate your patience and help.
Thank you very much Ashish_Mathur
It worked very well.
Apologies once again for not being clear from the start.
Regards.
You are welcome. No problem.