Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 , 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.
Awesome, thanks both 🙂
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |