Distributing Values to Other Columns Based On Another Value

[markefrody]

Hi,

Kindly assist me in creating a DAX for Power BI for the below:

I have the following data:

I need 2 new columns wherein it will show the "weight" value if there is a $ revenue or no $ revenue.  Below is the output: 

Please note I am using Direct Query as storage mode.

Appreciate your kind assistance. Thanks.

Best regards,
Mark V.

[amitchandak · Accepted solution]

@markefrody , Try new column like

col1 = if([revenue] =0, [weight], 0)

col2 = if([revenue] <>0, [weight], 0)

[markefrody]

Thanks @amitchandak. Confirmed working. Thanks!