Report Portal

SSAS Tabular Custom Prior Year Date Calculations

I am working on building a tabular cube and needed the ability to compare current fiscal year dates to prior fiscal year dates by matching the dates based on the same fiscal month and day of month and then performing calculations to compare sales between the current and prior fiscal year. The built-in DAX date calculations didn't appear to meet my needs (at least I wasn't able to obtain the desired results using them), so I implemented the necessary behavior using an inactive relationship from my date dimension to the sales fact table.

Read more...

Tags: design, dax, tabular

 

2007-2015 VidasSoft Systems Inc.