Can I compare text strings week-by-week?

[heyheyhey]

Let's say I have the following table - could I have Power BI let me know from current week to previous week whether the text string has changed or not?

Project	Extracted On	Update	Same as Last Week?
Project A	20/03/2018	Lorem ipsum dolor sit amet, consectetur adipiscing elit	Yes
Project A	13/03/2018	Lorem ipsum dolor sit amet, consectetur adipiscing elit	No
Project A	06/03/2018	Sed do eiusmod tempor incididunt ut labore	N/A
Project B	20/03/2018	Nemo enim ipsam voluptatem	No
Project B	13/03/2018	Sed ut perspiciatis unde omnis iste natus error sit	Yes
Project B	06/03/2018	Sed ut perspiciatis unde omnis iste natus error sit	N/A
Project C	20/03/2018	Neque porro quisquam est	Yes
Project C	13/03/2018	Neque porro quisquam est	Yes
Project C	06/03/2018	Neque porro quisquam est	N/A

Thank you

[Zubair_Muhammad]

HI @heyheyhey

Try this calculated column

Same as last week =
VAR Previous_Week =
    CALCULATE (
        MIN ( Table1[Update] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[Project] ),
            Table1[Extracted On]
                = EARLIER ( Table1[Extracted On] ) - 7
        )
    )
RETURN
    SWITCH (
        TRUE,
        Table1[Update] = Previous_Week, "Yes",
        ISBLANK ( Previous_Week ), "N/A",
        "No"
    )

[Zubair_Muhammad]

@heyheyhey