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.

amitchandak's avatar
amitchandak
Super User
6 years ago

chris_rowley , try this as column


Booked_Running Total = calculate(
sum(All_Data[BOOKED]),
filter(All_Data,
All_Data[DATE] <= EARLIER(All_Data[DATE])))

 

And this as a measure

 

Booked_Running Total = calculate(
sum(All_Data[BOOKED]),
filter(all(All_Data),
All_Data[DATE] <= max(All_Data[DATE])))