Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
75 | |
65 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |