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
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |