Comparing columns

[Anonymous]

Hi Team,

I have a dataset which comprises of new columns and old columns. I want to compare both of these columns values and store only modified fields in a column named Modified fields. I need to then show my values as old and new. I am adding snippet of the database structure and my requirment output. Any help will be appreciated.

Please let me know if you need more clarity on the requirement.

Thanks

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure about why QW C is not showing in your screenshot, but I tried to create a table like below.

Please check the below picture and the attached pbix file.

It is for creating a new table.

New Table = 
FILTER (
    SELECTCOLUMNS (
        GENERATE (
            VALUES ( Data[Case ID] ),
            {
                ( "A", CALCULATE ( SUM ( Data[Old A] ) ), CALCULATE ( SUM ( Data[New A] ) ) ),
                ( "B", CALCULATE ( SUM ( Data[Old B] ) ), CALCULATE ( SUM ( Data[New B] ) ) ),
                ( "C", CALCULATE ( SUM ( Data[Old C] ) ), CALCULATE ( SUM ( Data[New C] ) ) )
            }
        ),
        "@CASE ID", Data[Case ID],
        "@Modified fields", [Value1],
        "@Old Value", [Value2],
        "@New Value", [Value3]
    ),
    [@Old value] > [@New Value]
)

[Anonymous]

Thank you @Jihwan_Kim  for the solution.