Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
Show and Tell
  • PSBR's avatar
    PSBR
    7 years ago

    ==>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]))

PSBR's avatar
PSBR
Frequent Visitor
7 years ago

==>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]))