cancel
Showing results for
Did you mean:
Helper I

## How to do YOY and QOQ calculation using DAX

can someone help me how to perform YOY%, QOQ% calculation using DAX.

YOY%= mar-17(net_sale) - mar-16(net_sale)/mar-16(net_sale)

QOQ%= mar-08(net-sale) - dec-07(net_sale)/dec-07(net_sale)

NOTE : All the fields are in string format

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: How to do YOY and QOQ calculation using DAX

Hi @Darmesh,

Could you please mark the proper answer as solution?

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Microsoft

## Re: How to do YOY and QOQ calculation using DAX

Hi @Darmesh,

The first step is changing the data type to a proper type. You can try it out in this file.

1. Create a date table.

`Calendar = CALENDARAUTO()`

2. Establish relationships with other two tables.

3. Create two measures.

```YOY% =
VAR thisYear =
SUM ( YOY[Net_sales] )
VAR lastYear =
CALCULATE ( SUM ( YOY[Net_sales] ), SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) )
RETURN
DIVIDE ( thisYear - lastYear, lastYear, 0 )```
```QOQ% =
VAR thisQ =
SUM ( 'QOQ'[Net_sale] )
VAR lastQ =
CALCULATE (
SUM ( QOQ[Net_sale] ),
DATESINPERIOD ( 'Calendar'[Date], MIN ( 'Calendar'[Date] ), -1, QUARTER )
)
RETURN
DIVIDE ( thisQ - lastQ, lastQ, 0 )```

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft

## Re: How to do YOY and QOQ calculation using DAX

Hi @Darmesh,

Could you please mark the proper answer as solution?

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors