How do i do a DateAdd in MDX? eg. If the
How do i do a DateAdd in MDX? eg. If the current selected Month is [April 20008] and I want to return [April 2007], in sql its DataAdd('YY', -1, Year)... How is this done in MDX?
Tx
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)