KARTHIKEYAN.A
Reputation: 20108
How to select recent date or max date in a column in power bi?
We have Date table in Power Bi in that we have to select the max date or recent date for some purpose. How to select the same.
DATE
01/04/2020
02/04/2020
03/04/2020
04/04/2020
05/04/2020
06/04/2020
Upvotes: 0
Views: 15498
Answers (1)
KARTHIKEYAN.A
Reputation: 20108
We have to MAX function in DAX, use that one to get the value
DATEVALUE(MAX('Table'[DATE]))
The result is 06/04/2020
Upvotes: 2
Related Questions
- How to display the most Recent/Latest Value in Power Bi
- How can I get the latest date from a selection of dates in Power Query?
- How to select the last value of the day with DAX in Power BI
- Show latest value based on value in another column - Power BI
- How to calculate most recent (date wise) and MAX of prodcount in power BI using DAX
- How to add custom column for max date in Power BI query editor?
- How to Find the Most Current Date From a Column in Power Query - MAX()
- Power BI: how to select all columns where date is greater in Power BI
- Dynamic select latest date column in Power BI
- Power BI - max date or nearest date of selected date