Forum Discussion
Anonymous
3 years agoNot applicable
Trying to get data 12 months back from an excel sheet
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?
1 Reply
- AnonymousNot applicable
Nobody?