Forum Discussion

mmowrey's avatar
mmowrey
Icon for Helper I rankHelper I
4 years ago

Running total Power BI

I have a running total that stops calulating after 7 days and just inputs the last number continuously..    Here is my formula for running total: Monthly Running Total Goal (RBC) = IF( [Red Ce...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mmowrey , Do not check [Red Cell Projected] <> blank

 

Try like, assuming [Red Cell Projected] is  measure 

CALCULATE(
[Red Cell Projected],
FILTER(
ALLSELECTED(BloodDrive[DriveDate]),
BloodDrive[DriveDate]<= MAX(BloodDrive[DriveDate])))

 

Better to use date table

 

CALCULATE(
[Red Cell Projected],
FILTER(
ALLSELECTED(Date[Date]),
Date[Date]<= MAX(Date[Date])))

 

 

 


To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

 

 

mmowrey's avatar
mmowrey
Icon for Helper I rankHelper I
4 years ago

still getting the same value after a certain amount of days