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 All,
I'm trying to get a measure that will display the running balance carried over from previous month.
So here's what I'm tryin to do (C+D-E) will give me F as my closing balance then next month I carry over that closing balance and start again.
Thanks,
Marc
Solved! Go to Solution.
@r0ot5 , Assuming you have a date you can get like this
Closing Balance = CALCULATE(Table([Purcahse])-SUM(Table[Sales]),filter(allselected(Table),Table[date] <=max(Table[Date])))
@r0ot5 , Assuming you have a date you can get like this
Closing Balance = CALCULATE(Table([Purcahse])-SUM(Table[Sales]),filter(allselected(Table),Table[date] <=max(Table[Date])))
Thanks for help, that's exactly what I needed :).
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |