Create Blank query with data

[cristianml]

Hi,

I tried to create a table thru blank query with 12 rows and 2 columns but I have the following error:

= #table({"CY Month", "FY Period"},{{1,2,3,4,5,6,7,8,9,10,11,12},{5,6,7,8,9,10,11,12,1,2,3,4}})

What would be the issue ?

The idea for this is for mapping by lookup value a Fiscal Year period starting in September.

Thanks !

[wdx223_Daniel · Accepted solution]

= #table({"CY Month", "FY Period"},List.Zip({{1,2,3,4,5,6,7,8,9,10,11,12},{5,6,7,8,9,10,11,12,1,2,3,4}}))