Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi folks,
I've a challenge with Opening Balance 🙂 It works well for the first couple of rows but doesn't afterwards. Please help.
Sure, I'm missing a trick here.
Thanks,
Mahesh
Solved! Go to Solution.
Hi @MaheshMk
You can use the below pattern.
previousMonthRR = VAR _lpd = CALCULATE( LASTDATE( 'Calendar'[Date] ), PARALLELPERIOD( 'Calendar'[Date], -1, MONTH ) ) RETURN CALCULATE( SUM( Table[Added] ) - SUM( Table[Sold] ) + SUM( Table[Returned] ) 'Calendar'[Date] <= _lpd )
Hi @MaheshMk ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample as table format and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @MaheshMk
You can use the below pattern.
previousMonthRR = VAR _lpd = CALCULATE( LASTDATE( 'Calendar'[Date] ), PARALLELPERIOD( 'Calendar'[Date], -1, MONTH ) ) RETURN CALCULATE( SUM( Table[Added] ) - SUM( Table[Sold] ) + SUM( Table[Returned] ) 'Calendar'[Date] <= _lpd )
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |