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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ChrisW3
Frequent Visitor

DAX Comments in Power Pivot Measures

Is there a way to use comments in DAX measure formulas in Power Pivot? I tried both //...., and /*...*/, and while they show up in blue initially and seem to be understood as a comment, they disappear when the model calculates.

2 REPLIES 2
Arturo24
Frequent Visitor

Measure := //Apparently this comment will also disappear

SUM ([AMOUNT])

ChrisW3
Frequent Visitor

I figured out the solution to this. Sharing in case anyone else runs into the same problem. It seems that Power Pivot will remove comments in DAX code if they are not on a single line, and the single line has to be surrounded by other lines (can't be the last line). Seems like a strange bug. Why can't I end my code with a comment?

 

Measure:=SUM([Amount]) //This comment will be deleted by power pivot

 

Measure:=SUM([Amount])

               //This comment will also be delted by power pivot

 

Measure:=SUM([Amount])

              //This comment will be maintained because the next line is not blank

             +0

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.