Forum Discussion

markefrody's avatar
markefrody
Post Patron
3 years ago
Solved

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.