need to create a report to get the daily attrited Members based on the previous month data

[Swathykorivi]

I am new to power Bi, where i need to create a report for daily attrited members based on the previous month data.

I daily snapshot dates, new members acquired each snapshot date.

I need to calculate last month member as of last month.

here is the logic i need to get.

Last month members using the last month snapshot date.

daily net = total members - last month members

closed = new members - daily net, i have atatched the data for reference, can you please help.

[Swathykorivi]

@ahadkarimi Thank you for the solution

[ahadkarimi]

@Swathykorivi, You're welcome! Glad I could help!

[ahadkarimi · Accepted solution]

Hi @Swathykorivi, try these measures below, and if you encounter any issues, let me know.

LastMonthMembers = 
CALCULATE(
    SUM('Table'[New Members]),
    FILTER(
        'Table',
        'Table'[Date] = 
        CALCULATE(
            MAX('Table'[Date]),
            MONTH('Table'[Date]) = MONTH(TODAY()) - 1
        )
    )
)

DailyNet = SUM('Table'[Total accounts]) - [LastMonthMembers]

Closed = SUM('Table'[New Members]) - [DailyNet]

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!