Forum Discussion
Use Column Name as Filter
Dear Lydia,
Thanks for the reply. Let me give some clarity to the picture. This is the sample data:
| Practice | Employee | Activitity | 01-04-2011 | 01-05-2011 | 01-06-2011 |
| Project1 | Employee1 | Travel | 50000 | 50000 | 50000 |
| Project1 | Employee2 | Travel | 50010 | 50010 | 50010 |
| Project1 | Employee3 | Travel | 50020 | 50020 | 50020 |
| Project1 | Employee4 | Travel | 50030 | 50030 | 50030 |
Pls refer to the snapshots below:
1. Loading the data2. Choosing first row as header3. Result (issue)
Now, how can we make the date appear as such, after making the first row as header in the query editor???
In order to have values, other than text or numbers, promoted to headers, you must use the second argument of Table.PromoteHeaders as in:
= Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true])
Dear Marcel,
I did the same after undoing all the other changes except Promote Headers. I added [PromoteAllScalars=true] into the table formula, yet the same problem persists...!
Can you share another screenshot? With the Table.PoromoteHeader step as the last step, like in your step3 above, but with the adjusted formula? And also the step prior to that step, with the dates in the first row?