Calculating Changes in Cumulative/Appended Report

Hi Anonymous 
Thank you for reaching out microsoft fabric community forum.

you're right that the current logic only captures the first change, which isn't ideal when multiple fields can change at once.

The good news is, you don’t need to hardcode every combination. Instead, you can create a dynamic DAX expression that checks each field for changes and then combines any differences into a single "Change Type" field like:

“Cost Center Name Change + Cost Center Owner Change”

This way, it picks up all changes automatically, no matter how many fields you’re tracking. And if you prefer to list each change on a separate row (one per field), that’s also possible.


If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.