Add zero to previous months only

[Anonymous]

Hi,

I think this one should be pretty simple but for some reason I cannot think of a way to do it.

I have a measure to which I am adding zero.. measure = dax + 0 so I get 0 to plot on a graph that needs zero plots.

However, this graph has 2019 vs 2020 and now the zero values are on November and December 2020 too.

Any idea how I would stop that? Sort of like Add zero only IF the month is < current month.

[amitchandak · Accepted solution]

@Anonymous , Add a measure like

if( Max(Date[Date]) <= eomonth(today(),-1), [measure]+0,[measure])

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

Awesome, thanks both 🙂

[Anonymous]

Hi @Anonymous : You will get the current Month Value using

CurrentMonth= Month(Today())

You can use this in your IF Clause-

IF( Month < CurrentMonth, dax+ 0, dax)

Hope this helps.

Cheers,

-Namish B