Forum Discussion
DAX Query to MDX Cube
Found my issue. When I was trying to use calculated measures that referenced outside the date range eg. Year on Year comparison, then would not work if I used attributes of my date dimension. I needed to change the calculated measures to use the Key on the Date dimension. The problem I have is I'm using integer data types through my FACT tables which don't scale in Power BI visuals. I just have to convert to use the 4 byte DATE data type and all will be good.
Found my issue. When I was trying to use calculated measures that referenced outside the date range eg. Year on Year comparison, then would not work if I used attributes of my date dimension. I needed to change the calculated measures to use the Key on the Date dimension. The problem I have is I'm using integer data types through my FACT tables which don't scale in Power BI visuals. I just have to convert to use the 4 byte DATE data type and all will be good.
Phil
Can you expand a little more on your solutin to this issue? I am experienceing the exact same issue and have been looking at this for 3 days now. When you say you needed to have the Calculated Measures use the Key of the Date Dimension are you refering to the Scope statements for [Purchases Previous Year]? Are you saying other than using expressions like [Dates].[Year - Week - Day].currentmember.lag(1) you are using [Dates].[Key].members?