Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date table with no date column

Hi,    I have a data where i have just Period column with short month (Jan, Feb, Mar, Apr.......,Dec). Rest all the column in numbers with yearly sales numbers.  I want to convert the Period colum...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Can you clarify further?  I thought that is what was provided.  Can you show what the output table should look like?  Your data should be unpivoted for easiest analysis/visualization, and you will need a year component to convert the Period column to a date.

    Pat

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mahoneypat  

 

I tried this solution before posting the question but i have more than 20 columns with thousands of rows(didn't mentioned it earlier). 

Want to explore if the Month column could be covnverted into Date type and sales yearly column could be used with that column 


PA

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Can you clarify further?  I thought that is what was provided.  Can you show what the output table should look like?  Your data should be unpivoted for easiest analysis/visualization, and you will need a year component to convert the Period column to a date.

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi mahoneypat 

     

    I was not able to access this thread to repsond to your suggestion. 

    It's working now. I made date table and then  put a date column as suggested to get the issue resolved. 

     

    Thanks for the help.