Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Measure := //Apparently this comment will also disappear
SUM ([AMOUNT])
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |