Forum Discussion
Get the earliest dates
Hello,
In the above image i am trying to get the earliest dates for the case number. Unable to fetch any results with 'max' return dates dax function. Can someone help me with the dax function to return latest dates for the case number. Below are the images for reference.
From the above image, i should return 04/07/2022 which is an earliest date eliminating/removing the previous date. Likewise for all the case numbers.
Hi , Shailaja_PBI
According to your descripition, you want to get the latest retutrn date per case Number?
If this , you can refer to :
(1)This is my test data:(2)We can create a measure like this:
Measure = CALCULATE( MAX('Table'[Return Date]),ALLEXCEPT('Table','Table'[case Number]))Then we can put it on the visual , the result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi , Shailaja_PBI
According to your descripition, you want to get the latest retutrn date per case Number?
If this , you can refer to :
(1)This is my test data:(2)We can create a measure like this:
Measure = CALCULATE( MAX('Table'[Return Date]),ALLEXCEPT('Table','Table'[case Number]))Then we can put it on the visual , the result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly