Power BI

Completed

Support creating calculation groups in Power BI Desktop

Vote (3506)

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 (44)

Comments (44)

Paul Osuldsen on 06 Jul 2020 00:10:40

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

Adam Gilmore on 06 Jul 2020 00:10:37

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.

lewis hamilton on 06 Jul 2020 00:09:22

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] )
)

David Cresp on 06 Jul 2020 00:08:26

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.

Umar Ayub on 06 Jul 2020 00:07:44

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.

Power BI User on 06 Jul 2020 00:06:25

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