Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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" )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |