Power BI Power Query Tips: Age Calculations with Power Query DATE and DATETIME Functions
Few days ago I made a video which demonstrated a way to calculate dynamic age with DAX function. But in Some times we may need to have age calculated column by power query as the matching column or filter column to merge or transform other tables . Thus for such needs I suggested a way to calculate dynamic ages through sample file with the power query functions Date.Year, Date.Month, Date.Day and DateTime.LocalNow.
References:
Date.Year - PowerQuery M | Microsoft Learn
https://learn.microsoft.com/en-us/pow...
Date.Month - PowerQuery M | Microsoft Learn
https://learn.microsoft.com/en-us/pow...
Date.Day - PowerQuery M | Microsoft Learn
https://learn.microsoft.com/en-us/pow...
DateTime.LocalNow - PowerQuery M | Microsoft Learn
https://learn.microsoft.com/en-us/pow...
For more info of my BI & Analytics, please refer to the following website links:
My BI & Analytics Website:
https://sites.google.com/view/mikegua...
My blog website :
https://mikeyu.lovestoblog.com/
