Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Help please ,Im using this formula :
Cumulative Acutal =
CALCULATE (
SUM ( 'Cashflow'[Actual(AED)] ),
ALL ( 'Cashflow'),
'Cashflow'[Date] <= EARLIER ( 'Cashflow'[Date] ))
Solved! Go to Solution.
Hi @abusen,
Please try the formula below.
Column = VAR temp = CALCULATE ( SUM ( Table1[Sales] ), FILTER ( ALL ( Table1 ), 'Table1'[Date] <= EARLIER ( Table1[Date] ) ) ) RETURN IF ( ISBLANK ( 'Table1'[Sales] ), 0, temp )
Here is the output.
Best Regards,
Cherry
Hi @abusen,
Please try the formula below.
Column = VAR temp = CALCULATE ( SUM ( Table1[Sales] ), FILTER ( ALL ( Table1 ), 'Table1'[Date] <= EARLIER ( Table1[Date] ) ) ) RETURN IF ( ISBLANK ( 'Table1'[Sales] ), 0, temp )
Here is the output.
Best Regards,
Cherry
Hi, I don't have the same names as you but if I have:
TOTALYTD(SUM(Resultattransaktioner[Belopp justerat]);Datumkoppling[Datum])
I get all months.
But if I add a filter with DATESBETWEEN as in:
CALCULATE(TOTALYTD(SUM(Resultattransaktioner[Belopp justerat]);Datumkoppling[Datum]);DATESBETWEEN(Datumkoppling[Datum];MIN(Resultattransaktioner[Bokf datum]);MAX(Resultattransaktioner[Bokf datum])))
then I show only the months where Actual(AED) has value, the rest are zero. I have though a separate date table.
Can you explain more please