Reputation: 1
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
Reputation: 1
Check this video: https://www.youtube.com/watch?v=XEbwaPxXTUw
in short words:
=List.Max(#"your_last_step_name"[Date])
Upvotes: 0