Forum Discussion
markefrody
3 years agoPost Patron
Distributing Values to Other Columns Based On Another Value
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.
markefrody , Try new column like
col1 = if([revenue] =0, [weight], 0)
col2 = if([revenue] <>0, [weight], 0)
2 Replies
- amitchandakSuper User
markefrody , Try new column like
col1 = if([revenue] =0, [weight], 0)
col2 = if([revenue] <>0, [weight], 0)
- markefrodyPost Patron
Thanks amitchandak. Confirmed working. Thanks!