Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I have this excel sheet:
The data looks like this after loading in pbi:
My code
my measure=
IF(
HASONEFILTER('DSV Companies'[CompanyName]),
CALCULATE(
sum(Registrering[Verdi]),
FILTER(
Registrering,
Registrering[KPI_nr] = 3 &&
Registrering[Måned og År.Start of Month] >= EOMONTH(TODAY(), -12) &&
Registrering[Måned og År.Start of Month] <= EOMONTH(TODAY(), 0)
)
),
CALCULATE(
SUM(Registrering[Verdi]),
FILTER(
ALL(Registrering),
Registrering[Selskap] = "my company" &&
Registrering[KPI_nr] = 3 &&
Registrering[Måned og År.Start of Month] >= EOMONTH(TODAY(), -12) &&
Registrering[Måned og År.Start of Month] <= EOMONTH(TODAY(), 0)
)
)
)
Still, when I test I don't get data 12 months back. Even if I try 15 mohnts back it does no show the correct data. The above example gives me 1, and not 2.
Seems to be happening something when I'm reaching 12 months back.
Do you see whats wrong here?
Nobody?
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!
| User | Count |
|---|---|
| 7 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 14 | |
| 14 | |
| 10 | |
| 8 | |
| 8 |