Same period previous year issue

[Baroumy]

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 quarter number is 1, sum the sales turnover, actual sales - previous quarter sales) with the previous year's values. please check the table below :

the DAXs are as the below :

Sales by quarter = if([Quater No.]=1,sum('Client Aging'[Sales Turnover]),sum('Client Aging'[Sales Turnover])- [Sales PQ])

Sales PQ = CALCULATE(SUM('Client Aging'[Sales Turnover]),PREVIOUSQUARTER('Calendar'[date]))

Sales by quarter PY = CALCULATE([Sales by quarter],SAMEPERIODLASTYEAR('Calendar'[date]))

Any help ??

[Baroumy]

Thank you @amitchandak . It worked.

[amitchandak · Accepted solution]

@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])