Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
5 years ago
Solved

Create Blank query with data

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 !

 

  • = #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}}))

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

    = #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}}))