The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I would like to combine rows that are identical and neighboring, see example below.
The order of the entries matters, since they have been listed chronologically.
Removing duplicates doesn't work, since the blue and grey rows are identical yet not neighboring.
I'd be grateful for any ideas how this could be solved 🙂
Kind regards,
Jama1234
Solved! Go to Solution.
@Anonymous
Hi
Select all the 3 columns>>>From the Transform Tab>>Group BY.
In the formula bar, just modify the formula by adding the text in red font below
= Table.Group(#"Changed Type", {"ID", "State", "Previous State"}, {{"ALL", each _, type table [ID=text, State=text, Previous State=text]}},GroupKind.Local)
@Anonymous
Hi
Select all the 3 columns>>>From the Transform Tab>>Group BY.
In the formula bar, just modify the formula by adding the text in red font below
= Table.Group(#"Changed Type", {"ID", "State", "Previous State"}, {{"ALL", each _, type table [ID=text, State=text, Previous State=text]}},GroupKind.Local)
Works perfectly! Thank you