Convert Fiscal Year, Quarter, Week from String to Date Format

[Anonymous]

Is there a way where I can easily convert my fiscal year, quarter, week columns with string values into a date format? Im trying to achieve this Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

Table below show the example valeus of what my columns look like

FiscalYear	FiscalQuarter	FiscalWeek	Quarter	Work Week
2020	3	2021_36	20Q3	W36
2022	1	2022_01	22Q1	W01
2023	4	2023_51	23Q4	W51

[Ahmedx · Accepted solution]

see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RhluoCaM9rvpRLd_9?e=kp8AGH
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhlpWHMb531WBDXTL?e=XqVkeW

[Ahmedx]

[Ahmedx]

Is this what you are looking for?

[Anonymous]

This is exactly it. How can i achieve that?

[Ahmedx]

do you have a calendar?

one more question, what month does the calendar year start from?

[Anonymous]

I do have a calendar made by @KNP in Solved: Creating a Fiscal Calendar with 52 Weeks - Microsoft Power BI Community. However, his power query code needs to be adjusted such as inputting the years with 53 weeks in a Fiscal Calendar. I want a calendar that can automatically detect years with 53 weeks (e.g. 2007, 2012, 2018) so I thought of just converting my data into a date format rather than creating a new calendar.