The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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: January: 2, February 2, March 3, April 4, May 4, June 5, July 5 and so on...
I don't know how to implement this. I tried to use the quick measures and came pretty close. The formular so far:
CumulativeCount =
IF(
ISFILTERED('Tabelle1'[Eingetragen am]),
ERROR("Quickmeasures mit Zeitintelligenz können nur über die von Power BI bereitgestellte Datumshierarchie oder die primäre Datumsspalte gruppiert oder gefiltert werden."),
CALCULATE(
COUNTA('Tabelle1'[Name]),
FILTER(
ALL('Tabelle1'[Eingetragen am]),
'Tabelle1'[Eingetragen am] <= MAX('Tabelle1'[Eingetragen am])
)
)
)
My Date Table (calculated table)
is linked like this:
What it looks like:
if I select "show elements without values" it's not what I want 😞
Any help is appreciated! Thanks in advance!
@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