last 3 months

[kasife]

Guys, good afternoon!

I'm having difficulty creating a measurement. What I want to get is the last 3 months within the bar chart. I took a measurement, but it seems to be accumulating

CALCULATE(
    [repasses Realizados],
    FILTER(
        ALL(d_calendario),
        d_calendario[Date] >= EDATE(MAX(d_calendario[Date]), -3)
            && d_calendario[Date] <= MAX(d_calendario[Date])
    )
)

I want to get the last 3 months, but without using the screen filter

How a do it?

[xifeng_L · Accepted solution]

Hi @kasife ,

You can try below measure:

CALCULATE(
    [repasses Realizados],
    KEEPFILTERS(
        DATESINPERIOD(d_calendario[Date],EOMONTH(TODAY(),0),-3,MONTH)
    )
)

The key is the KEEPFILTERS function.

If I solve your problem , pls mark my post as a solution and appreciate your Kudos !

Thank you~

[kasife]

@xifeng_L  it worked. Thank you so much .

[bhanu_gautam]

@kasife , You can try using below measure

Last 3 Months Total =
CALCULATE(
[repasses Realizados],
DATESINPERIOD(
d_calendario[Date],
TODAY(),
-3,
MONTH
)
)

[kasife]

@bhanu_gautam I tried it and didn't work.