Forum Discussion
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...
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()))))
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.