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! 🙂

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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

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

    Thank you both. 

    Time logic will not work, so I will stay with the current version.

     

    Quarters are indeed a pain, but not the only one :-).