Forum Discussion

Baroumy's avatar
Baroumy
Regular Visitor
3 years ago
Solved

Same period previous year issue

Hello,   I m trying to get a trend for the actual and previous dates. The problem is I'm using a logical test for the values of the first quarter's sales which I believe is not working ( if the qua...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Baroumy , try like. All three are for Last year Qtr

     

    Sales Last Year = CALCULATE(sum('Client Aging'[Sales Turnover]) ,SAMEPERIODLASTYEAR('Calendar'[date]))

    Sales LPQ = CALCULATE(SUM('Client Aging'[Sales Turnover]),PREVIOUSQUARTER(dateadd('Calendar'[date],-4,QUARTER)))

    Sales LY quarter = if([Quater No.]=1,[Sales Last Year],[Sales Last Year]- [Sales LPQ])