Preceeding 12 quarters from selected filter Q Year

[Tani4ka]

Hello,

Would be grateful for some help resolving my case.

I need to create a measure that will allow users to see 9 quarters prior and including the one they select in the filter (10 quarters on the chart)

So far my measure works partially: the quarter users select shows only the 1st month values of the selected but other quarters are correctly displayed. I can't figure out why and how to make the selected quarter also showing the full 3 months values instead of one.

On the below you can see I selected Q4 25 and the value in the bar chart shoudl be 9.6M but it returns only 3.5 that matches the first month of Q4 25. 

My measure is next:

Visits Last 13 Quarters =

VAR AnchorDate =

    COALESCE (

        SELECTEDVALUE ( 'dim_time'[Start of Quarter] ),  

        MAX (visits[date] )       

    )

VAR AxisQ = SELECTEDVALUE ( 'Presentation Calendar'[Start of Quarter] )

RETURN

CALCULATE (

    [Value],

    REMOVEFILTERS ( 'dim_time' ),                      

    KEEPFILTERS ( DATESINPERIOD ( 'dim_time'[Date], AnchorDate, -9, QUARTER ) ),

    TREATAS ( { AxisQ }, 'dim_time'[Start of Quarter] )

)

I tried to change the measure to use Quarter Year insted  but it's not in the date format hence the measure doesn't work. 

Visits - table with the date and the value 

dim_time - calendar that used for filters

Presentation Calendar - calendar used for measure .  (Presentation Calendar = dim_site)

Many thanks!

[Tani4ka]

Thank you  SOOOO MUCH! 

[rohit1991 · Accepted solution]

Hii @Tani4ka 

The issue happens because your selected quarter filter is restricting the date table to the first month only, and your AnchorDate comes from that filtered context. So for the selected quarter, DATESINPERIOD is anchored to the first month, not the full quarter.

You should anchor on the end of the selected quarter, not the start.

Visits Last 9 Quarters =
VAR AnchorDate =
    COALESCE(
        ENDOFQUARTER('dim_time'[Date]),
        MAX('dim_time'[Date])
    )
RETURN
CALCULATE(
    [Value],
    REMOVEFILTERS('dim_time'),
    DATESINPERIOD(
        'dim_time'[Date],
        AnchorDate,
        -9,
        QUARTER
    )
)