Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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" )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
60 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |