Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys,
I need your help please.
I have a Datetime table (full calendar), and another table related to it, with appointment data.
I need to show the variatiion of number of appoitments by Month, in a WaterFall chart.
Actually, I have a filter on a customer, who had only 2 records on October in whole 2017.
So normally, the variation in October should be +2, and in November -2, December 0.
Unfortunatly, it's not what I have, I got only +2 in october, and that's it.
So this is the formulas of my measure:
DIFF_RDV_byMONTH:=-(calculate(sum(Interaction[NbRDVbyRow]); PARALLELPERIOD(DateDim[Date];-1;MONTH))+calculate(sum(Interaction[NbRDVbyRow])))
Thanks for your help.
regards
Solved! Go to Solution.
Hi @powerbi_seek
I tried to rebuilt your issue and for me it seems to work.
2 things. Change both operators and (just for optic) use PREVIOUSMONTH() instead
=CALCULATE(SUM(factAppointments[Appointments]))-CALCULATE(SUM(factAppointments[Appointments]);PREVIOUSMONTH(Kalender[Date]))
But I also tried it with Parallelperiod() and it worked as well.
Hi @powerbi_seek
I tried to rebuilt your issue and for me it seems to work.
2 things. Change both operators and (just for optic) use PREVIOUSMONTH() instead
=CALCULATE(SUM(factAppointments[Appointments]))-CALCULATE(SUM(factAppointments[Appointments]);PREVIOUSMONTH(Kalender[Date]))
But I also tried it with Parallelperiod() and it worked as well.
Can you please show a visual ?
I got it, my issue is related to January. I made an IF statement to do that only if the month is not January. And that seems not working
I think this should work as well. The whole calculation should be surounded by a CALCULATE() that has a filter condition "not January"
CALCULATE([Total Appointments]-CALCULATE([Total Appointments];PREVIOUSMONTH(DateTable[Date]));DateTable[Date].[Monat]<>"Januar")
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |