cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Darmesh Frequent Visitor
Frequent Visitor

How to do YOY and QOQ calculation using DAX

YOY.PNGQOQ.PNG

 

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

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

How_to_do_YOY_and_QOQ_calculation_using_DAX

 

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

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.