Forum Discussion
cristianml
5 years agoPost Prodigy
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_DanielCommunity 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}}))