Calendar issue

[jnn4282]

https://app.powerbi.com/links/iIz-nEedoY?ctid=f75c0628-6e7b-41e9-86a8-0f32146077da&pbi_source=linkSh...

Hi friends,

I want your help. My data table only has FY and month columns, as you can see from the above link.
I am working with the company's PL(Dummy).
I want to sort months starting April ( 04) as 1. Our FY begins in April and ends in March.
How can I create a relationship with a calendar table?
I cant Month as date data type.

Is there any support, please?

[amitchandak]

@jnn4282 , I have a calendar code with sort columns, see if that can help

https://amitchandak.medium.com/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[jnn4282]

Thank you for the calendar and works perfectly.

But how do I connect to my PL table( relationship)? Since my PL table does not have any Date data type.

[v-jingzhang]

Hi @jnn4282 

Can you please show some dummy data of your PL table? If it doesn't have any date data type columns, you can add columns like "Month Start Date", "Month End Date" based on existing columns like Month, Year or any date related columns you have in PL table. Then build a relationship between "Month Start Date" (or "Month End Date") and the Date column in Calendar table. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[jnn4282]

Dear @v-jingzhang 

Can you download bi file from the link below?

https://app.powerbi.com/links/iIz-nEedoY?ctid=f75c0628-6e7b-41e9-86a8-0f32146077da&pbi_source=linkSh...

[v-jingzhang]

Hi @jnn4282 

No, I cannot download it. 

Jing

[jnn4282]

Thank you so much for your support.

I have created a link for my pbix file.

https://we.tl/t-4y9fNW0K0u

[jnn4282]

Thank you @amitchandak 

I will check the link you provided. Then, if I get stocked somewhere, I will approach again.