Forum Discussion

Abhilash_P's avatar
Abhilash_P
Super User
3 years ago
Solved

Last date from date column

Hello Eveyone, I have sales, sales date column i want to create measure which shows last date from sales date column  sales date column in used in filter pane and Measure has to show Last date from...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Abhilash_P 

     

    A simple measure with MAX is able to meet your requirement.

    Latest Sales Date = MAX('TableName'[Sales Date])

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago
Suppoing your table named Data, try to create a measure with this:
LastDate = MAX(VALUES(Data[Sales Date))