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.
Dear Community,
Let me explain the problem.
1st : We have Data from Hotel Reservations
2nd: We want to Sum Net Difference of reservations and cancellations (Reservations - Cancellations)
3rd : Reservations should be calculated with System Date when they add in system reservation
4th : Cancellation should be calculated with Cancelation Date when they cancel it.
5th : Visual this difference as cummulative For example : 1st day : 100 reservations 50 cancellations = net 50 2nd day : 70 reservations 20 cancellation = 50 +(70-20) = 100 3rd day : 10 reservations 70 cancellations = 100(last day total) + (10-70) = 40
So we will have at the end a diagram with "System Date" (maybe) that each day will have total information per day.
Any Solution on that ?
Thanks in advance
Solved! Go to Solution.
@SpiroswayGR , You can join both dates with the same date table. One Active and One Inactive join will be there. You can use userelation to choose the join
@SpiroswayGR , You can join both dates with the same date table. One Active and One Inactive join will be there. You can use userelation to choose the join
@amitchandak Looks like that is the solution that i am looking for.
I will try to apply it on my data. In case , that is not working on me . Can i share some "fake data" to help me around with solution ?
Thanks in advance
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |