Power BI

Planned

Support creating calculation groups in Power BI Desktop

Vote (3498)

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.

Administrator on 18 Oct 2022 00:54:51

Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo

This is in our backlog. Stay tuned for more updates!

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