How to create new column based on criteria from other columns

[lsihui_]

Hi, 

I am quite new to PBI so would need help to create a new column (new value) based on the below sample data. Thank you. 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

It is for creating a new calculated column.

Please check the below picture and the attached pbix file.

new_value CC = 
VAR _grouptable =
    FILTER ( data, data[group] = EARLIER ( data[group] ) )
VAR _maxvalue =
    MAXX ( _grouptable, data[value] )
VAR _maxproperty =
    SUMMARIZE ( FILTER ( _grouptable, data[value] = _maxvalue ), data[property] )
RETURN
    IF (
        data[value] = _maxvalue,
        data[value]
            - SUMX (
                FILTER ( _grouptable, NOT ( data[property] IN _maxproperty ) ),
                data[value]
            )
    )

[lsihui_]

Thanks Jihwan for your prompt response. Your intepretation is correct. 

What if the property column does not use/contain numbers? Example below. 

[v-zhangtin-msft]

Hi, @lsihui_ 

Have you solved your problem? If it has been resolved, please accept the reply that helped you as a solution. If it has not been resolved, please provide more information.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi,

I think it is still the same.

Please check the below picture and the attached pbix file.

Thank you.