DAX Time Intelligence Functions
DAX
Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
Difference between LASTDATE and MAX for semi-additive measures in #DAX
Semi-Additive Measures in DAX - SQLBI
Keep rows that begin with alphabetical characters - The Ken Puls (Excelguru) BlogThe Ken Puls (Excelguru) Blog
Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot - PowerPivotPro
Kasper de Jonge PowerPivot and Power BI Blog | Get the YTD of same period last year using DAX
How about a FIRSTDATE()? - PowerPivotPro
Defanging the “contiguous date selections” error - PowerPivotPro
The Greatest Formula in the World, Part 3 - PowerPivotPro
Power BI Desktop, Sort By Column And DAX Calculations That Use The All() Function – Chris Webb's BI Blog
Precedence Part 3: ALLEXCEPT vs. ALL w/ VALUES - PowerPivotPro
Detecting ALL() - Detecting When Not Filtered - PowerPivotPro
When to Use Measures vs. Calc Columns - PowerPivotPro
Portable formulas: A PowerPivot benefit you won't believe you lived without, part 2 - Office Blogs
Organizing Your Measures With a “Dummy” Table – Guest Post From Eric Hutton - PowerPivotPro
A mystifying and awesome solution for many 2 many - PowerPivotPro
Why PowerPivot is Better Fed from a Database, Pt2 - PowerPivotPro
Quick Tip: Don’t Over-Use FILTER() - PowerPivotPro
The Superheroes of DAX, and derived measures - PowerPivotPro
Not your average PowerPivot report
PowerPivot time intelligent functions: why use ALL() and how to work around it - PowerPivotPro
Another way to get and use slicer values in formulas - PowerPivotPro
Counting “Active” Rows in a Time Period: Guest Post from Chris Campbell - PowerPivotPro
“Normalize” Your Measures for Fun and Profit! - PowerPivotPro
CALCULATE(): More Examples and Reinforcement - PowerPivotPro
Toggling Between Different Units via Slicer? - PowerPivotPro
Repeat Customers in DAX: Three Flavors - PowerPivotPro
The Diabolical Genius of “SWITCH TRUE” - PowerPivotPro
New Twist for Dynamic Segmentation: Variable Grain Control - PowerPivotPro