Forum Discussion

Anshu_Joshi's avatar
Anshu_Joshi
Frequent Visitor
3 years ago
Solved

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

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.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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