Hi! I like your post and I see how it wo
Hi! I like your post and I see how it works when I'm in BIDS, but when I try to browse the data in Excel 2007, I can't see the data, only Current Period. Any reason why I can't see the rest?
Thanks!
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)