Conditional Column

[Syndicate_Admin]

Good morning

I want to see if there is a shape with any conditional columns or with the M language and see the following:

In the carbon text column the carbon numbers are displayed, for example the carbon text "7" has the value "49.2" but the next carbon text "7" has the value "null", I want to generate a condition where if the carbon 7 or another number has a value, it must be replicated in the other values that it has as "null". I got this column from a dynamization override.

Thank you.

[v-zhangti · Accepted solution]

Hi, @Syndicate_Admin 

You can try the following methods. In the Power BI Desktop, use Dax:

Column =
IF ( [Value] = "null",
    CALCULATE ( MAX ( 'Table'[Value] ),
        FILTER ( 'Table', [Carbon] = EARLIER ( 'Table'[Carbon] ) && [Value] <> "null" )
    ),
    [Value]
)

Is this the result you expect?

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.

[Ritaf1983]

Hi @Syndicate_Admin 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523