Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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