Based on year selection to show previous quarter

[sreddy47652]

Hi Team, I have directquery model and i need to show based on year selection on slicer i want show ouarter wise and  for example 2024 q1 should show value for 2023 Q4, if 2024 Q2 the value should show 2023 Q1 value like below. I need to show result like below query.

[v-bofeng-msft · Accepted solution]

Hi @sreddy47652 ,

I’ve made a test for your reference:

1\I assume there is a table

2\Create a measure

NewSumOfValue =

 CALCULATE(

    MAX(Table1[Value]),

    REMOVEFILTERS(Table1),

    (Table1[Year] = (MAX(Table1[Year]) - 1) && Table1[Quarter] = 4) ||

    (Table1[Year] = MAX(Table1[Year]) && Table1[Quarter] = (MAX(Table1[Quarter]) - 1))

)

3\Result

Best Regards,

Bof

[Tahreem24]

  Try this DAX Measure:Last year same QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,Year)))

@sreddy47652

[sreddy47652]

@Tahreem24  As i mentioned it's directquery mode and time intelligence functions will not work.