Forum Discussion

dp32's avatar
dp32
Icon for Helper I rankHelper I
6 years ago
Solved

Filter year/quarter in a calculation

I want to filter the current years quarter in a calculation. Currently I am using two filters like this: A02 = CALCULATE(A01, FILTER(PT, [PTDate].[Year]=YEAR([ActualDate])), FILTER( PT, [PTDate].[Q...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    dp32 That looks reasonable to me. Quarters are a pain! 🙂

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi dp32 ,

 

You may change your code like below:

 

A02 =
CALCULATE (
    [A01],
    FILTER (
        PT,
        [PTDate].[Year] = YEAR ( [ActualDate] )
            && [PTDate].[QuarterNo] = QUARTER ( [ActualDate] )
    )
)

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.