convert tableau calculation to get the weeks instead month:case [FI290 D_Fiscal Month of Year]
when 1 then DATE(STR([FI320 D_Fiscal Year])+'-04-01')
when 2 then DATE(STR([FI320 D_Fiscal Year])+'-05-01')
when 3 then DATE(STR([FI320 D_Fiscal Year])+'-06-01')
when 4 then DATE(STR([FI320 D_Fiscal Year])+'-07-01')
when 5 then DATE(STR([FI320 D_Fiscal Year])+'-08-01')
when 6 then DATE(STR([FI320 D_Fiscal Year])+'-09-01')
when 7 then DATE(STR([FI320 D_Fiscal Year])+'-10-01')
when 8 then DATE(STR([FI320 D_Fiscal Year])+'-11-01')
when 9 then DATE(STR([FI320 D_Fiscal Year])+'-12-01')
when 10 then DATE(STR([FI320 D_Fiscal Year])+'-01-01')
when 11 then DATE(STR([FI320 D_Fiscal Year])+'-02-01')
when 12 then DATE(STR([FI320 D_Fiscal Year])+'-03-01')
END