JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
In PQ I have this list, all values text:
I'm trying to convert the date strings into dates using
But I receive error 2 arguments passed to a function which expects 1.
Can anyone suggest correction?
TIA,
Jack
In PQ I have this list, all values text:
| Kunj Shah BindalFX Trade Journal.xlsm | |||
|---|---|---|---|
| A | |||
| 33 | Monday | ||
| 34 | 17/05/2021 | ||
| 35 | 24/05/2021 | ||
| 36 | 31/05/2021 | ||
| 37 | 07/06/2021 | ||
Dashboard | |||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A33:A37 | A33 | =TRANSPOSE(Rolling_4Week_Stats[#Headers]) |
| Dynamic array formulas. | ||
I'm trying to convert the date strings into dates using
Power Query:
= List.Accumulate(Table.ColumnNames(HeaderRow),1, (xDate) => Date.FromText(xDate))But I receive error 2 arguments passed to a function which expects 1.
Can anyone suggest correction?
TIA,
Jack
