Forum Discussion

AColan's avatar
AColan
Frequent Visitor
5 years ago
Solved

Need Help Formatting Table Columns

Prefacing this by saying this is my first post to a forum like this, so if you need more clarifications let me know. I also had to make this example because I have a rough format of this on Power BI ...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi, @AColan

    1.Depend on the data you have applied, I create the table below.

    2.Create a Matrix as below.

    3.Create two measures as below:

    Total sales =

    COUNT(Table1[Method])

     

    Avarage price of sales =

    AVERAGE(Table1[Price])

    4.Calculate the sum of price and rename it to Total Money Earned.

     

    5.Drag all columns into Matrix.

    Here is the demo, please try it: Need Help Formatting Table Columns

    Best Regards,

    Link Chen

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi, @AColan

1.Depend on the data you have applied, I create the table below.

2.Create a Matrix as below.

3.Create two measures as below:

Total sales =

COUNT(Table1[Method])

 

Avarage price of sales =

AVERAGE(Table1[Price])

4.Calculate the sum of price and rename it to Total Money Earned.

 

5.Drag all columns into Matrix.

Here is the demo, please try it: Need Help Formatting Table Columns

Best Regards,

Link Chen

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.