Forum Discussion
No Values Column showing
I'm trying to show a year of monthly totals, then the variance between the last two months. This is working fine, except the variance column is showing for each month eventhough the values in those columns are 'no value'.
My measure is:
MoVariance:=IF(MAX(balSheet[Date])=CALCULATE( MAX(balSheet[Date]), ALLSELECTED('balSheet')),
CALCULATE([PrevMoVar], LASTDATE(balSheet[Date])))
As you can see, I'm getting the correct variance, but I am also getting these 'no value' columns. I do not have "Show items with no data on columns" checked. I do not have "Show items with no data on rows" checked.
Any idea how to get rid of them?
Fixed it... Incase anyone else is finding this issue, the Values fields must be first in the Columns section. I had the Date first.
1 Reply
Fixed it... Incase anyone else is finding this issue, the Values fields must be first in the Columns section. I had the Date first.