DAX formula to calculate difference between current Q and previous Q.

[RilwanFlame]

Hi all- 

 I have the below data, and looking to calculate the difference between the current Q from the previous Q. 

So far, i have the formula: 

QoQ $ =

IF(

    ISFILTERED('ICC Reports'[Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    VAR __PREV_QUARTER = CALCULATE(SUM('ICC Reports'[$]), DATEADD('ICC Reports'[Date].[Date], -1, QUARTER))

    RETURN

        DIVIDE(SUM('ICC Reports'[$]) - __PREV_QUARTER, __PREV_QUARTER)

)

Thank you

[amitchandak]

@RilwanFlame , Always use date table if you want time intelligence to work . Joined with date of you table .

Also no .[Date]

IF(
ISFILTERED('ICC Reports'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __PREV_QUARTER = CALCULATE(SUM('ICC Reports'[$]), DATEADD('Date'[Date], -1, QUARTER))
RETURN
DIVIDE(SUM('ICC Reports'[$]) - __PREV_QUARTER, __PREV_QUARTER)
)

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
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 :radacad sqlbi My Video Series Appreciate your Kudos.

[RilwanFlame]

Thank you for your response. Below is basically what i am trying to calculate in power BI 

QoQ Change = I5-H5

YTD Change = I5 - G5

So far my Power BI calculation: