Forum Discussion
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...
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.
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