Forum Discussion

ROFELLM's avatar
ROFELLM
Regular Visitor
2 years ago

cumulative count for all rows by date question

Hello all, DAX Beginner here. I need help with a formular.   My dummy data: I'd like to have a bar chart, where it cumalates each entry. "Eingetragen am" is my date column. What I expect: ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

ROFELLM , better to use a date table joined with your table and use it in visual , measure and slicer

 

CALCULATE(

COUNTA('Tabelle1'[Name]),

FILTER(

ALL('Date'),

'Date'[Date] <= MAX('Date'[Date])

)

)

 

 

Running Total/ Cumulative:
https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

 

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f