Forum Discussion
Chris_23
Helper II
Helper IIDifferent refresh scenario under 365 and 2016
Hallo guys, i've built a Excel-report with some query and vba components on Microsoft365. Everything works fine if the user has an 365 license. however, if the user has a 2016 standard license th...
Hi Chris_23 ,
Based on my test, there must be 4 parameters for Table.AddIndexColumn() in Excel 2016
= Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)and 5 parameters in Power BI , the last one is to define column Type which is optional,as the official document said:
Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number, optional columnType as nullable type) as table
=Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type)= Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Chris_23 ,
Based on my test, there must be 4 parameters for Table.AddIndexColumn() in Excel 2016
= Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)
and 5 parameters in Power BI , the last one is to define column Type which is optional,as the official document said:
Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number, optional columnType as nullable type) as table
=Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type)
= Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.