Forum Discussion

lorenzc's avatar
lorenzc
Frequent Visitor
3 years ago

Column headers formatted as date from pivot column with date values

Hi all, I struggle to arrive at column headers formatted as dates in my Power Query output table. My searches haven't helped me so far, hence this post.   In the Power Query, a date Date column is...
Need Help
KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
3 years ago

Hi lorenzc ,

 

Try the code below after the Table.Pivot step:

Table.TransformColumns(
     PreviousStepName,
     {
       { "Week Ending", Date.From, en.DE}
     }
)

 

Regards

KT