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 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 ??

 

 

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    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])