Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Helper 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()))))

bilalkhokar73's avatar
bilalkhokar73
Helper IV
5 years ago

I got solution but here i face one issue when i am making growth degrwoth for quarter 3 , degrwoth shwoing high 

I need quarter 3 till date , measn quarter 3 start from  1july to 30sept 2020 and 2021, so for 1 july to till date i need quarter 2020 and quarter 2021

Q32021 = var _max = date(year(today()),9 ,30) var _min = date(year(today()),7 ,1)
return CALCULATE(sum(sales[Amt]), FILTER(ALL(DATE),DATE[date] >=_min && DATE[date] <= _max) )

Q32020 = var _max = date(year(today())-1,9 ,30) var _min = date(year(today())-1,7 ,1)
return CALCULATE(sum(sales[Amt]), FILTER(ALL(DATE),DATE[date] >=_min && DATE[date] <= _max) )


Q3 20V21% = var _grow=DIVIDE([Q32021]-[Q32020],[Q32020],BLANK())
return IF([Q32021]>[Q32020],ABS(_grow),-ABS(_grow))