Difficult Task - Cumulative but Net Difference

[SpiroswayGR]

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

[amitchandak · Accepted 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

Refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[SpiroswayGR]

@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