Great use for the ClosingPeriod function
Great use for the ClosingPeriod function. Small remark: it should be lag(11) els you get 13 months
Top Tags
Latest Posts
- Dynamic format strings with calculation groups
- Set functions in DAX: UNION, INTERSECT, and EXCEPT
- Announcing improved MDX query performance in Power BI
- Using Many to Many for Running Sum
- Creating a simpler and chart-friendly Date table in Power BI
- Introduction to DAX Financial Functions – Part 1
- Understanding the difference between LASTDATE and MAX in DAX
- Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)
- Using calculation groups to selectively replace measures in DAX expressions
- Default calculation item in calculation groups
Most Read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- Microsoft SQL Server Analysis Services (SSAS) Books
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- Time MDX Cheat Sheets
- Newsletter And RSS
- Analysis Services 2000 and 2005 Connection string properties
- How to fix Analysis Services deployment error No mapping between account names and security IDs was done
- Script to automate SSAS partition management (SQL + SSIS)