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.

parry2k's avatar
parry2k
Super User
6 years ago

chris_rowley very hard to make sense out of your data table, can you paste the table with fewer columns and make sure these are not overlapping and merged together and also share what is your expected output.