Hi Team,
How to calculate below highlighted calculations,
Thanks,
Chandrasekhar
1 ACCEPTED SOLUTION
Hello @sekhar438
Give this a try.
RunningSum =
VAR CurrentDate = SELECTEDVALUE ( 'Table'[date] )
RETURN
SUM ( 'Table'[D.qty] ) -
CALCULATE( SUM ( 'Table'[r.qty] ),
ALL ( 'Table' ),
'Table'[date] <= CurrentDate
)
Hello @sekhar438
Give this a try.
RunningSum =
VAR CurrentDate = SELECTEDVALUE ( 'Table'[date] )
RETURN
SUM ( 'Table'[D.qty] ) -
CALCULATE( SUM ( 'Table'[r.qty] ),
ALL ( 'Table' ),
'Table'[date] <= CurrentDate
)
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
