SQL Help

[fbostan1]

Any help would be appreacited. I am new in SQL and I'm trying to write a sql query from table1 to give me the result in table 2

Table1: 

Table2: 

[v-henryk-mstf · Accepted solution]

Hi @fbostan1 ,

This result can be quickly achieved by using matrix visual in powerbi desktop, refer to the following screenshot.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@fbostan1 , Use Matrix Visual Velocity at row , column at column and sales as value

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual