Forum Discussion
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 ...
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.
Hi,
To your matrix visual, drag Method to the column labels & Employee ID and Date to the row labels. Write this measure
Measure = sum(data[price])
Hope this helps.