Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Support creating calculation groups in Power BI Desktop

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.
Status: Completed
Comments
dcresp1
New Member
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.
lewishamilton30
New Member
'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] ) )
ina_hoogeland
New Member
This would be great to use in combination with matrix tables. Would be great if it could be implemented soon!
wade_mcgriff
New Member
looks like we are getting this via XMLA endpoints which will allow 3rd party tool connectivity for tabular editor which will allow you to create calculation groups (also the new Enhanced Metadata preview feature). Exciting! This also solved the not being able to graph custom formatted numbers!
paul_osuldsen1
New Member
This is very useful in Financial reporting for reporting Profit & Loss Budget versus Actual and time dimention YTD LYD
agilmore30
New Member
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.
alexisolson1
New Member
This really needed since workaround switching measures have serious performance issues.
paul72
New Member
This function would help a lot all kind of measures like budget deviation forecast deviation i financial reporting. It would save us a lot of measures
pbiideas1
New Member
Please prioritize!
nurgali_omar
New Member
please prioritise this as it's an amazing tool