Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
heyheyhey
Frequent Visitor

Can I compare text strings week-by-week?

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?

 

 

ProjectExtracted OnUpdateSame as Last Week?
Project A20/03/2018Lorem ipsum dolor sit amet, consectetur adipiscing elitYes
Project A13/03/2018Lorem ipsum dolor sit amet, consectetur adipiscing elitNo 
Project A06/03/2018Sed do eiusmod tempor incididunt ut labore N/A 
Project B20/03/2018Nemo enim ipsam voluptatemNo
Project B13/03/2018Sed ut perspiciatis unde omnis iste natus error sit Yes 
Project B06/03/2018Sed ut perspiciatis unde omnis iste natus error sitN/A 
Project C20/03/2018Neque porro quisquam est Yes
Project C13/03/2018Neque porro quisquam estYes 
Project C06/03/2018Neque porro quisquam estN/A 

 

Thank you

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

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"
    )

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.