Forum Discussion

pel20's avatar
pel20
Regular Visitor
8 months ago
Solved

unpivoting columns and creating datetime column

I have some power consumption data that is taken every 30 minutes in the following form:   How can I get this to display in two columns: a DateTime value, then a consumption value? If I unpiv...
Need Help
  • danextian's avatar
    danextian
    8 months ago

    Hi pel20 

    The problem is you simply unpivoted the whole table as there is nothing inside {}. There is nothing in there that should be excluded from being unpivoted. Right-click Reading Date column and then unpivot other columns.

     

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
8 months ago

Hi pel20 

 

You'll need to adjust you formula to add the columns you want to remain grouped in the curly bracket. For example, in your case, just the 'Reading Date':

Table.UnpivotOtherColumns(#"Removed Columns", {"Reading Date"}, "Attribute", "Value")