Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We are currently on SQL Server 2016 SSAS Standard, which does not support Calculation Groups.
We plan to migrate to Power BI Service but until then, are there alternatives to Calculation Groups?
Thank you.
Solved! Go to Solution.
The only alternative is to create multiple measures. For example with calculation groups you could create time intelligence items for MTD, QTD and YTD and have a single [Sales] measure. In SSAS 2016 you'd have to create 3 additional measures [Sales MTD], [Sales QTD] and [Sales YTD]
However my suggestion would be to use Tabular Editor (see tabulareditor.com ) to build out these variations that could otherwise be done with calculation groups. One approach is to create all your base measures in a display folder called something like "Current" then you can then either write a script or create a custom action to add time intelligence variations to all the selected measures. I've used this approach in the past to build out a solution with 10+ time intelligence variations and it works really well.
This was what I figured, but did not consider the scripting. I use Tabular Editor and am just learning about that scripting capability.
Thank you for affirming that this is the only alternative until later versions / Online Service and pointing the way via scripting out the measures.
The only alternative is to create multiple measures. For example with calculation groups you could create time intelligence items for MTD, QTD and YTD and have a single [Sales] measure. In SSAS 2016 you'd have to create 3 additional measures [Sales MTD], [Sales QTD] and [Sales YTD]
However my suggestion would be to use Tabular Editor (see tabulareditor.com ) to build out these variations that could otherwise be done with calculation groups. One approach is to create all your base measures in a display folder called something like "Current" then you can then either write a script or create a custom action to add time intelligence variations to all the selected measures. I've used this approach in the past to build out a solution with 10+ time intelligence variations and it works really well.
This was what I figured, but did not consider the scripting. I use Tabular Editor and am just learning about that scripting capability.
Thank you for affirming that this is the only alternative until later versions / Online Service and pointing the way via scripting out the measures.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |