Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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]
it does not seem to work
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 3 |