Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

MoM creates additional month with value -100%

Hi community, Probably something that is easy but I am fairly new to PowerBI. So I have a matrix Report and I have months as columns. Every time I use the quick measure for MoM calculation. The m...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Try it this way

=if(isblank(distinctcount(your column)),blank(),[your measure])

Hope this helps.