Forum Discussion
Syndicate_Admin
Administrator
3 years agoCumulative Total with multiple filter selection
I have a database containing dates from different years and 7 projects (which are segmented by different types) of which, I need to generate a table containing: 1. Income 2. Expenses 3. Income ...
parry2k
Super User
3 years agoSyndicate_Admin change this part, although when you are working dates, you should have date dimension in your model.
CALCULATE ( SUM('FLUJOSPROYPRUEBA'[I-E]), FILTER ( ALL ( Table[Date] ), Table[Date] <= MAX ( Table[Date] ) ) )
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️