Data Vs Data Points Vs Metrics Vs KPIs. Bringing clarity to chaos.
Data Vs Data Points Vs Metrics Vs KPIs
Calculating Age (duration or difference between two dates) in years, months and days in Power Query M Script
16-Jul turns out to be the birthday of Microsoft Power BI. Here I post a formula in M Script to calculate the age (i.e., duration or difference between two dates) in years, months and days: let Source= [ PowerBIBDay = #date(2014, 7, 16), Today = Date.From(DateTime.LocalNow()), BirthdayFactor = if Date.DayOfYear(PowerBIBDay)<Date.DayOfYear(Today) then 0 else 1, DayFactor... Continue Reading →
Share this:
Generating Date Dimension data in Microsoft Excel
Generating data for populating Date Dimension table using familiar Microsoft Excel
