Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Add zero to previous months only

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
5 years ago
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.

3 Replies

amitchandak
Super User
5 years ago
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
  Not applicable
  5 years ago
  Awesome, thanks both 🙂
Anonymous
Not applicable
5 years ago
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