Measure to show QOQ growth values between quarter values. show that as Tool Tip in current Quarter

[ssk_1984]

Hi, 

Pleaes help me to create measure to show QOQ growth % between quarters vales and show it in current quarter as tool tip.

QOQ Growth 4M in Qtr4 - Compared with Q3 108 M and Q4 112 M 

Date tables in related reference as well

[johnt75 · Accepted solution]

You can create a measure like

QoQ % =
VAR CurQuarter = [Revenue]
VAR PrevQuarter =
    CALCULATE ( [Revenue], PREVIOUSQUARTER ( 'Date'[Date] ) )
VAR Result =
    DIVIDE ( CurQuarter - PrevQuarter, PrevQuarter )
RETURN
    Result

and add that to the tooltip for the chart.

[ssk_1984]

Values is showing 0% for every quarter values...as tool tip

[ssk_1984]

Calender table what i have is

[Bibiano_Geraldo · Accepted solution]

Hi @ssk_1984 ,

In your date table add a new column to sort the quarter by this DAX:

Quarter_No = YEAR('Calendar'[Date]) & QUARTER('Calendar'[Date])

Make sure that this column the data type was set to Whole Number:

Now add another column for quarter-year by this DAX:

Year-Quarter = FORMAT([Date], "YYYY-Q")

Now create the QoQ Growth % Measure by this DAX:

QoQ Growth % = 
VAR CurrentQuarter = MAX('Calendar'[Year-Quarter])
VAR CurrentQuarterValue = 
    CALCULATE(
        SUM(SalesOrderLines[Sales Amount]),
        'Calendar'[Year-Quarter] = CurrentQuarter
    )
VAR vPreviousQuarter = 
    CALCULATE(
        MAX('Calendar'[Year-Quarter]),
        DATEADD('Calendar'[Date], -1, QUARTER)
    )
VAR PreviousQuarterValue = 
    CALCULATE(
        SUM(SalesOrderLines[Sales Amount]),
        FILTER(
            ALLSELECTED('Calendar'),
            'Calendar'[Year-Quarter] = vPreviousQuarter
        )
    )

RETURN
    IF(
        ISBLANK(PreviousQuarterValue),
        BLANK(),
        DIVIDE(
            CurrentQuarterValue - PreviousQuarterValue,
            PreviousQuarterValue,
            0
        )
    )

Now put the year quarter in x-axis and sales in Y-axis and QOQ % in tooltips

Your final result should look like this:

[ssk_1984]

Thank you very much

[johnt75 · Accepted solution]

You can create a measure like

QoQ % =
VAR CurQuarter = [Revenue]
VAR PrevQuarter =
    CALCULATE ( [Revenue], PREVIOUSQUARTER ( 'Date'[Date] ) )
VAR Result =
    DIVIDE ( CurQuarter - PrevQuarter, PrevQuarter )
RETURN
    Result

and add that to the tooltip for the chart.

[ssk_1984]

Thank you for you help, i will test and accept this solution