Forum Discussion

chris_rowley's avatar
chris_rowley
Frequent Visitor
6 years ago
Solved

Running Total using a base value from another table

So i have a table (1) currenlty with columns calculating runnings totals,   Booked_Running Total = calculate( sum(All_Data[BOOKED]), all(All_Data), All_Data[DATE] <= EARLIER(All_Data[DATE]))   ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  chris_rowley 

    Use this formula

    Booked_Running Total = calculate(
sum(All_Data[Bookings]),
FILTER(all(All_Data),
All_Data[Date of Booking / Referral] <= EARLIER(All_Data[Date of Booking / Referral])))+SUM('Table(2)'[Overall_Total])

    and why it doesn't answer your issue

     

    please share your sample pbix file and your expected output.

     

    Regards,

    Lin

  • chris_rowley's avatar
    chris_rowley
    6 years ago

    v-lili6-msft  that solution worked perfectly much appreciated thank you.

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  chris_rowley 

If just create column as below in table(1)?

New column 1=SUM('Table(2)'[Cumulative Bookings (inc. Rebookings) ])+'Table(1)'[Booked_Running Total]

 

New column 2=SUM('Table(2)'[Cumulative Bookings (ex.. Rebookings) ])+'Table(1)'[Booked (ex.Rebooked)]

 

If not your case, please share your logic and expected output.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

Lin