Power BI DAX: Dynamic Age Calculation with DATEDIFF and FORMAT

Опубликовано: 12 Октябрь 2024
на канале: Mike YU (BI&Analytics)

3,948

The video demonstrates the DAX formulas to calculate the dynamic age of measured person acoording to his birthday and his measured BP reading date. By these dynamic ages we may link the right age group of BP range chart to check BP value of measured person, aslo we may construct line chart to montior the personal historic BP values with conditional format via field values of calculated age column.

References:

The DAX functions used in this video:

FORMAT function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...

DATEDIFF function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...

VALUES function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...

IF function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...

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 for this video :
https://mikeyubianalytics.blogspot.co...