cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors