Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Icon for Helper IV rankHelper IV
5 years ago
Solved

Quarter Formula

1. I want dynamic quarter 1 thsi year last year formula, 2. I want to see growth vs degrwoth Q1_Currenteeyar vs Q1LAst year This formual givign me wrong results , it just displaying values from 8 j...
Need Help
  • bilalkhokar73's avatar
    bilalkhokar73
    5 years ago

    no that is date , my typing error

     

    CALCULATE(SUM(Sales[Amt]),FILTER(date,date[Date]>=DATE(YEAR(TODAY()),1,DAY(TODAY()))&& date[Date]<=DATE(YEAR(TODAY()),3,DAY(TODAY()))))

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

bilalkhokar73 

Can you provide more information as to what you are try to achieve?

In your formula, what is tm_date? you do not reference it in the filter arguments.

  • bilalkhokar73's avatar
    bilalkhokar73
    Icon for Helper IV rankHelper IV
    5 years ago

    no that is date , my typing error

     

    CALCULATE(SUM(Sales[Amt]),FILTER(date,date[Date]>=DATE(YEAR(TODAY()),1,DAY(TODAY()))&& date[Date]<=DATE(YEAR(TODAY()),3,DAY(TODAY()))))