Replacing Fiscal week with the max of the date in the week

Hi All, 

Good morning! 

I have a dataset with three columns, Fiscal-week, Date and Count.  

I have a create a line chart with Fiscal week as Columns and Count as Rows ( Sheet 2 in the attached workbook Test_AD) . 

In the view I am trying to replace the Fiscal week with the max of the date in the fiscal week , for example FY23W27 should be replaced by 4/1/2023. Is there any calculation that I can use to achieve this. 

Also to note, the fiscal week does not align with a particular day of the week so changing the week start day and using date instead of fiscal week does not work in this case.

Any suggestions would be helpful.

Thank you! 

Regards,

RishiSaka