Hello
In this link Table visualizations in Power BI reports and dashboards - Power BI you see the table below:
2
How can I create that table when my data is like the Table1 below:
Womens Product 1 Price1 Last Year Sales1
Womens Product 2 Price2 Last Year Sales2
etc?
Basically, I need to create a table where I will have the row 010-Womens Products and next to it, I will have AVG(Table1[Price] and SUM(Table1[Last Year Sales]) as values in the cells to the right.
Any idea?
Thanks!
In this link Table visualizations in Power BI reports and dashboards - Power BI you see the table below:

How can I create that table when my data is like the Table1 below:
Womens Product 1 Price1 Last Year Sales1
Womens Product 2 Price2 Last Year Sales2
etc?
Basically, I need to create a table where I will have the row 010-Womens Products and next to it, I will have AVG(Table1[Price] and SUM(Table1[Last Year Sales]) as values in the cells to the right.
Any idea?
Thanks!