cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

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

1 ACCEPTED SOLUTION
Super User

@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 2
Regular Visitor

Thank you @amitchandak . It worked.

Super User

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

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors