sudipto
Reputation: 1
How to get latest date using Power Query Editor in Power BI
I have a dataset which have 3 attributes.
The requirement is to create a new column which should have the latest date from the "Date" column. This should be a dynamic approach because in every refresh the dataset may change and I want the latest date should also get change in the new column after the refresh.
I have to create this in Power Query Editor of Power BI.
How can this be done?
Upvotes: 0
Views: 16358
Answers (1)
slimcube
Reputation: 1
Check this video: https://www.youtube.com/watch?v=XEbwaPxXTUw
in short words:
- add custom column
- in colum definition type formula
=List.Max(#"your_last_step_name"[Date])
Upvotes: 0
Related Questions
- Data for most recent date in Power BI for each year
- 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 recent date or max date in a column in power bi?
- How to add custom column for max date in Power BI query editor?
- PowerQuery - Finding Most Recent Date Based on Given Value and Current Date
- How to Find the Most Current Date From a Column in Power Query - MAX()
- Dynamic select latest date column in Power BI
- Power BI - max date or nearest date of selected date
- How to get latest record for matching ID and date in Power BI Query Editor