Logic and Visualization for Current Month vs Previous month's trend analysis

[Anshu_Joshi]

Hi Team,

I have the data of customers for 6 months(Jan - Jun)  where I have to show the comparison for Current month (June) vs Previous months (January - May). How can I create this logic to compare total number of customers for above comparison?

also please suggest some visuals.

[v-shex-msft · Accepted solution]

HI @Anshu_Joshi,

It sounds like a common rolling aggregate calculate requirements. For this scenario, I you can extract the current date to store in variable. Then you can use that variable with date function to get result and as condition in expression to filter and limit the calculation ranges.

formula =
VAR currDate =
    MAX ( Table[Date] )
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER (
            ALLSELECTED ( Table ),
            [Date]
                >= DATE ( YEAR ( currDate ), MONTH ( currDate ) - 5, DAY ( currDate ) )
                && [Date] <= currDate
        )
    )

Regards,

Xiaoxin Sheng