Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
9 years ago
Solved

Date Imported

Hi All,    Hope you have a great day.  I have daily sale report which included around 66 rows of products name and 30 columns of date from 01 to 30. I had imported the data with series of rows a...
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Chanleakna123,

     

    What is your desired output? Could you illustrate your requirement with an example? Do you want to modify the table structure in data view? Or do you want to achieve a more readable view in report view (visualization) ?

     

    Regards,
    Yuliana Gu

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

Hi v-yulgu-msft, 


Yes , i did unpivot the date to a row , then it will included on 01 Aug 2017 with 66 products Names. Hence, for 30 days will be 66*30. I'm not sure whether everyone did this. 
Thanks you so much for your response :) 

Best Regards, 
Chanleakna Hang 

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Chanleakna123,

 

What is your desired output? Could you illustrate your requirement with an example? Do you want to modify the table structure in data view? Or do you want to achieve a more readable view in report view (visualization) ?

 

Regards,
Yuliana Gu

  • Chanleakna123's avatar
    Chanleakna123
    Post Prodigy
    8 years ago

    Hi v-yulgu-msft

    i had unpivoted the columns and rows, these consists a lots of row with what i'm doing now. I think , only this way can works. 

    Your solutions was also help. 

    Thanks you with Best Regards,