Forum Discussion
AdministratorAssign Dynamic Periods to the Calendar
Good day, I'm new to power Bi
I want to create a column in the Calendar table where a period is assigned to a year-month dynamically
for example nov2021 period 24
octubre2021 period 23
until the corresponding Nov2020 period 1, in a dynamic way
if then we enter December 2021 that becomes the period 24
and November 2021 in the period 23
I hope and can help me. Thank you
1 Reply
Hi Syndicate_Admin ,
I'm not quite sure if I understand your needs accurately. please see if the blog below helps:
create-dynamic-periods-for-fiscal-or-calendar-dates-in-power-bi
Sample data without sensitive information and expected output would help tremendously.
Please see this post regarding:How to get your question answered quickly
How-to-provide-sample-data-in-the-Power-BI-Forum
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
