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.
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")
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |