cancel
Showing results for
Did you mean:
Frequent Visitor

## 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
Community Support Team

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

Hi @Darmesh,

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
Community Support Team

## 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.
Community Support Team

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

Hi @Darmesh,

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.