Forum Discussion

heyheyhey's avatar
heyheyhey
Frequent Visitor
8 years ago

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

Need Help

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

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