Forum Discussion

Frequent Visitor

7 years ago

Solved

Select Min Date Based on Calculations

Hello All, I am trying to write some logic in Dax, to get the minimum date where the total open is greater than 5% of the total open volume. In the screenshot below, if i just use min(Date)...

Need Help

PattemManohar
7 years ago
reggiete Not sure whether you tried this or not... I've tried the same with the sample data posted and got the expected output...

_Total Calculates the SUM of TotalOpen
_FivePercentofTotal Gives the 5% of the _Total
_MinDate Calculates the Minimum Date outof the records that contain TotalOpen >= 5% of TotalOpen

Finally, returning the MinDate as the output.

Hope this helps !! Let me make it clear, if my understanding of your requirement is wrong....