Forum Discussion

dilshad_ahmed's avatar
dilshad_ahmed
Frequent Visitor
3 years ago

[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:

 

But in Power BI I am getting this result:

 

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

  • 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