Quarter over Quarter growth for each year

[Jos13]

Hi Team,

I just wanted to show a line chart of QoQ growth for each year. I have data from 2017 Jan to 2019 Dec. I am using a date table for growth calculation. My calculation is as follows.

Sale QoQ% =

    VAR __PREV_QUARTER =

        CALCULATE(

            SUM('Sales'[Sale]),

            DATEADD('DateTable'[Date], -1, QUARTER)

        )

    RETURN

        DIVIDE(SUM('Sales'[Sale]) - __PREV_QUARTER, __PREV_QUARTER)

This calculation will show QoQ growth from 2017 to 2019. But I am looking for something like the below chart, instead of exact sale I want growth to be displayed so that I can see what happened in each quarter for each year.

[v-gizhi-msft]

Hi,

Do you want to show comparison among Quarters for each year, like 2017-Q1 with 2018-Q1,2017-Q2 with 2018-Q2?

If so, please try to change your measure to this:

Sale QoQ% =
    VAR __PREV_QUARTER =
        CALCULATE(
            SUM('Sales'[Sale]),
            DATEADD('DateTable'[Date], -1, YEAR)
        )
    RETURN
        DIVIDE(SUM('Sales'[Sale]) - __PREV_QUARTER, __PREV_QUARTER)

Best Regards,

Giotto Zhi

[amitchandak]

You can Use Time intelligence function. You need Date table for that. Example

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
Last to last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-2,QUARTER)))
Next QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],1,QUARTER)))

Last year same QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,Year)))

 You can take diff between QTD and Last QTD

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/