Replace current month value with empty (white)

[Anonymous]

 

I would like to remove the value of the current month in the column in orange, so that it is not visible in the chart, it can be a blank value. Any rule that for this month, March is blank, but for the next month, it changes automatic, so that it is always just the current month blank. So, when we are in the next month, it will have the value of March but not the value of April (current month).

I already have the date calendar table (dCalender) and also the sum of the column I want (sum of sales).

The report page is filtered for the 12 months of the current year.

Thansk!! I'm Brazilian, so sorry for any language error.

[amitchandak · Accepted solution]

@Anonymous , Based on what I got, You do not want current month unless completed

a new measure =

if(eomonth(max(date[Date]),0) = eomonth(Today(),0), blank(), [Current Month])

[Anonymous]

I did this and it worked!! Thank you very much @amitchandak