Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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" )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |