Forum Discussion

kasife's avatar
kasife
Icon for Helper V rankHelper V
2 years ago
Solved

last 3 months

 

 

 

 

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?

 

 

Need Help
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    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~

     

     

4 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    kasife , You can try using below measure

     

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

  • xifeng_L's avatar
    xifeng_L
    Icon for Super User rankSuper User
    2 years ago

    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~