Forum Discussion

myteam's avatar
myteam
New Member
4 years ago

Cube.ApplyParameter how to select from a List

HI PowerBI,    I have the below FISCAL Period YYYYMMM.. How do I write this so it select everything from "2021001" thru to "22025012" ... 

 

= Cube.Transform(ZCV_FI_CP01_V1,

        {

            {Cube.ApplyParameter, "FISCAL_PERIOD", {"2022003"}},

            {Cube.AddAndExpandDimensionColumn, "[ZCV_FI_CP01_V2]

Need Help

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi myteam ,

     

    Please try replacing {"2022003"} with the following list

    List.Combine({{2021001..2021012},{2022001..2022012}})

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.