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.
1st post and only been using Power BI for 2 weeks !
I'm trying to build a cashflow report to show running balances across multiple bank accounts/nominal codes, I used the quick measure function but it only gave me the option to use one field for the running total. I need to calculate on the date and the nominal, by using the quick set-up I think it is adding up across all nominal codes with the same dates.
Net Balance running total in Date =
CALCULATE(
SUM('Sage Trans Raw Data'[Net Balance]),
FILTER(
ALLSELECTED('Sage Trans Raw Data'[Date]),
ISONORAFTER('Sage Trans Raw Data'[Date], MAX('Sage Trans Raw Data'[Date]), DESC)
)
)
Thanks
Steve
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 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |