Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I've done cumulative running totals before, but this is frustrating. I can't get it to work. My formula is correct, and I think my values are correct, but the graph is messed up looking.
Running Total COLUMN = CALCULATE ( SUM ( Table1[Tran Amount] ), ALL ( Table1 ), Table1[TrueDate] <= EARLIER ( Table1[TrueDate] ) )
The only major issue is that my dates are in serial form from Excel and when I try to convert in Power BI I get an error, so I read I had to have a calculated column to make the serials into dates. Yes, I formatted the column as a date. And there's no relationships here, all information is in one table.
TrueDate = FORMAT(Table1[Post Date],"YYYY-MM-DD")
@Anonymous,
This looks fine. It would be better to share a complete example.
I've done cumulative running totals before, but this is frustrating. I can't get it to work. My formula is correct, and I think my values are correct, but the graph is messed up looking.
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
43 | |
41 | |
39 | |
36 |