Forum Discussion

Wael03's avatar
Wael03
Helper I
3 years ago

Create a table

Hello,

 

I will try to explain my problem but it is a little bit complex to understand. So basically, I have a dataset in which each rows represent a transaction. Each transaction can be considered either "native" or "cobadge. The thing is I try to create a table to show the repartition between "native" and "cobadge" in this dataset, here is what I want from Excel I try to do it in powerbi : 

I don't know how to create 2 rows and calculate everything based on those two rows.

Can anyone help me ?

 

Thank you!

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Wael03 ,
    Can you share sample data and sample output in table format?

     

    The output you have shown, we can get in matrix visual, if "native" and  "cobadge are row values