Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dilshad_ahmed
Frequent Visitor

[URGENT] HELP FOR MATRIX TABLE

 
Hi Folks,

 

I have sales and closing supply data by week number. Below is the underlying data:

Week NumberProductClosing SupplySales
W1Maruti100125
W2Maruti50356
W3Maruti150458
W4Maruti260621
W5Maruti30020
W1Innova125325
W2Innova15125
W3Innova195458
W4Innova365478
W5Innova246695
W1XUV154555
W2XUV856222
W3XUV654351
W4XUV854545
W5XUV215

 

215

 

 

I want to have a matrix table with week number as column for closing supply but do not want sales column for every week rather a single column. Below is the result that I want to achieve:

dilshad_ahmed_1-1679315662345.png

 

But in Power BI I am getting this result:

dilshad_ahmed_0-1679315627301.png

 

Is there any way to achieve the  desired result?

Link to PBIX file: https://drive.google.com/file/d/1Vm480X8HqFuzfByQoHMG_b6SpzmGi_Dp/view?usp=sharing

Thanks in Advance

 

2 REPLIES 2
amitchandak
Super User
Super User

@dilshad_ahmed , there is some problem in your excel(first Scrrenshot), that is complete sales data available in the file in the first column

 

I am getting the same value in excel

amitchandak_0-1679321114579.png

 

@amitchandak I want to achieve sum of sales in one column only, and not in every week.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.