Help With calculating month over month percent change quick measure

[Anonymous]

I am trying to calculate the % change month over month for the count of the ID's. Each ID entered is a new lead and hence why I am counting each ID. 

Here is my Code below: 

ID MoM% =

IF(

    ISFILTERED('Cross Sales Tracker'[Date Submitted]),

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

    VAR __PREV_MONTH =

        CALCULATE(

            COUNTA('Cross Sales Tracker'[ID]),

            DATEADD('Cross Sales Tracker'[Date Submitted].[Date], -1, MONTH)

        )

    RETURN

        DIVIDE(COUNTA('Cross Sales Tracker'[ID]) - __PREV_MONTH, __PREV_MONTH)

)

[amitchandak]

@Anonymous , You should date table for time intelligence

example

Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))

do not use .date.

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-bd52912a5bd4
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.

[Anonymous · Accepted solution]

I ended up using this and it worked but I did switch to Q/Q:

ID QoQ% =

IF(

    ISFILTERED('Dates'[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(

            COUNTA('Cross Sales Tracker'[ID]),

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

        )

    RETURN

        DIVIDE(

            COUNTA('Cross Sales Tracker'[ID]) - __PREV_QUARTER,

            __PREV_QUARTER

        )

)