Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm using combined line & bar graph to show sales this year per month, compares to same period last year and calculating the growth between those. The result looks like:
Nice growth or what! 😉
The problem here is that I would like to have the growth calculated (and visualized) only for full months, since the numbers are just nonsense after that. As you can see the current month (2022 02) has negative growth today, since the growth measure is comparing partial month this year to full month last year and rest of the year flatlines into -100% for same reason.
My growth measure is simple: Growth% = DIVIDE ( [Sales Total] - [Sales last year] , [Sales last year] ) , where those measures are just what the name says.
What I would need is simple IF(?) to check if the month is finished or not and if it's not yet finished, the growth value should be empty (would that stop drawing the line in the graph?) or at least zero.
I was thinking about LASTMONTH or MONTH < MONTH(Today()) kind of solutions, but didn't get it working right.
Any help is once again very appreciated.
Solved! Go to Solution.
@vpsoini , Try measure like
if(eomonth(Max(Date[Date]),0) >=today(), blank(), [Growth% ])
@vpsoini , Try measure like
if(eomonth(Max(Date[Date]),0) >=today(), blank(), [Growth% ])
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |