Power BI DAX: Dynamic Age Calculation with DATEDIFF and FORMAT скачать в хорошем качестве

Power BI DAX: Dynamic Age Calculation with DATEDIFF and FORMAT

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...