Need help in writing calculated column

Hello manojk_pbi,
Thank you for reaching out to the Microsoft Fabric Community Forum.

I have reproduced your scenario in Power BI Desktop using the sample data you provided. I implemented a DAX calculated column (PrevKPI) to copy the previous month’s KPI value for the same PROJECT_NAME and RELEASE_NAME and the output matches your expected result (Tabl2).

 

For your reference, I’ve attached a .pbix file containing the solution. You can download it, open it in Power BI Desktop, and review the table to see the PrevKPI column in action. The DAX code used is as follows:

PrevKPI =

VAR CurrentMonthYear = Tabl1[MONTH_YEAR]

VAR CurrentProject = Tabl1[PROJECT_NAME]

VAR CurrentRelease = Tabl1[RELEASE_NAME]

VAR CurrentDate =

    DATEVALUE(RIGHT(Tabl1[FILTER_MONTH_YEAR_KEY], 10))

VAR PrevMonthDate = EDATE(CurrentDate, -1)

VAR PrevKPI =

    CALCULATE(

        MAX(Tabl1[KPI]),

        FILTER(

            Tabl1,

            Tabl1[PROJECT_NAME] = CurrentProject &&

            Tabl1[RELEASE_NAME] = CurrentRelease &&

            DATEVALUE(RIGHT(Tabl1[FILTER_MONTH_YEAR_KEY], 10)) = PrevMonthDate

        )

    )

RETURN

    PrevKPI

If you have any further questions, please don't hesitate to contact us through the community. We are happy to assist you.

Best Regards,
Ganesh singamshetty.