Forum Discussion
LATEST DATE
Hi,
In my dataset I have multiple values that changes every day in a month, and I want to get the latest value.
How can I do this, without using "max" or "last" when adding the visualizations?
Thank you very much
==>Measure 1= MAX(Orders[Order Date].[Date])
when you use "measure 1" you will get last date in total value. If you want show last date for all values in table you can use below "measure 2". here Orders is a table name and Order date is a Date field name.
==>Measure 2= CALCULATE(MAX(Orders[Order Date].[Date]),ALLEXCEPT(Orders,Orders[Order Date].[Date]))
1 Reply
==>Measure 1= MAX(Orders[Order Date].[Date])
when you use "measure 1" you will get last date in total value. If you want show last date for all values in table you can use below "measure 2". here Orders is a table name and Order date is a Date field name.
==>Measure 2= CALCULATE(MAX(Orders[Order Date].[Date]),ALLEXCEPT(Orders,Orders[Order Date].[Date]))