Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to 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.
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.
@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