Marco Russo on 20 Mar 2019 01:59:47
Support the creation of DAX calculation groups in Power BI Desktop - otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model.
Even just a simple text window with a script would be fine. You can clean up the UI later.
Thanks.
Zoe Douglas (administrator) on 22 Nov 2023 16:53:24
Released for public preview with Model Explorer in October 2023. https://learn.microsoft.com/power-bi/transform-model/calculation-groups
- Comments (45)
RE: Support creating calculation groups in Power BI Desktop
This would be great to use in combination with matrix tables. Would be great if it could be implemented soon!
RE: Support creating calculation groups in Power BI Desktop
This is very useful in Financial reporting for reporting Profit & Loss Budget versus Actual and time dimention YTD LYD
RE: Support creating calculation groups in Power BI Desktop
Our requirement is to filter a fact table by one of 15 calendar relationships (through USERELATIONSHIP), and one of 5 currencies depending on the user's selection, or a default if they don't select a Calendar or a Currency.
It's almost impossible to achieve without this feature.
RE: Support creating calculation groups in Power BI Desktop
'The comment preceding each DAX expression identifies the corresponding calculation item:
-- Calculation Item: YTD
--
CALCULATE (
SELECTEDMEASURE () ,
DATESYTD ( 'Date'[Date] )
)
--
-- Calculation Item: QTD
--
CALCULATE (
SELECTEDMEASURE () ,
DATESQTD ( 'Date'[Date] )
)
--
-- Calculation Item: SPLY
--
CALCULATE (
SELECTEDMEASURE () ,
SAMEPERIODLASTYEAR ( 'Date'[Date] )
)
RE: Support creating calculation groups in Power BI Desktop
This is really needed and would help performance in a dashboard that I am working on a lot. Please bring this sooner rather than later.
RE: Support creating calculation groups in Power BI Desktop
Hi it would be great to have this functionality when connected to a Tabular model. We've got quite a few financial reports that require custom groupings due to different focus areas for different business units. Pushing all of this report specific logic into the model just makes us less agile. We've been relying on uncertified Power BI grid (financial matrix) controls from Market place to get around this.
RE: Support creating calculation groups in Power BI Desktop
This is absolutely vital and needed. Otherwise, it becomes obsolete for most of us since the costs are way too high. good concept of re-usability in PowerBI, I support Marco's Suggestion of implementing this in PowerBI update earlier than scheduled.
xoxo
Goodmann for
https://führerschein-online-kaufen.com/personalausweis-falschen-kaufen
RE: Support creating calculation groups in Power BI Desktop
This would be great I hope especially for performance
RE: Support creating calculation groups in Power BI Desktop
This would save tons of time!
RE: Support creating calculation groups in Power BI Desktop
Very important feature!