Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
This measure almost works:
Bogført beløb (Akk. Dags dato) =
VAR __MaxYT = MAX(DimDato[År])
var __MaxDT = max(DimDato[Dato])
var __TD = EOMONTH(TODAY(),1)
var __Rtotal =
CALCULATE([Bogført beløb],
Filter(
All(DimDato),
DimDato[År] = __MaxYT
&& DimDato[Dato] <= __MaxDT)
)
RETURN
IF (__MaxDT >= __TD, BLANK(), __Rtotal)
This gives a cumulative total up til current date and the month ahead is blank.
All is nice and ok, but when I changes it to quarters, the current quarter is gone?
I need it to show the amount of sales up til current date in current month or current quarter. Is that possible if altering the measure?
@Bokazoit , You can put additional filter for
Bogført beløb (Akk. Dags dato) =
VAR __MaxYT = MAX(DimDato[År])
var __MaxDT = max(DimDato[Dato])
var __TD = EOMONTH(TODAY(),1)
var __Rtotal =
CALCULATE([Bogført beløb],
Filter(
All(DimDato),
DimDato[År] = __MaxYT
&& DimDato[Dato] <= __MaxDT && DimDato[Dato] <=today())
)
RETURN
IF (__MaxDT >= __TD, BLANK(), __Rtotal)
// month end
&& DimDato[Dato] <= eomonth(today(),0)
That does not change a thing...
I need it to show sales up til Q3 which we are currently in now:
@Bokazoit , can you change to 0 and test
var __TD = EOMONTH(TODAY(),0)
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Still the same
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!