Last 4 complete fiscal week representation

Hi All,

Good afternoon!

I have a table with three fields, Fiscal_week, Date and Count.  ( attached the workbook - Last 4 complete Fiscal Week)

The line graph ( Sheet 2(2)) should only show the last 4 complete fiscal weeks.

So for the present data, the graph should only have the data from FY24W32 FY24W33, FY24E34, FY24W35. It should not show 

Fy24W36 since it is not a complete week ( 6 days only) 

FY24W38 since it is not a complete week(1 day only).  

I have done the below calculations 

To represent the Fiscal week with max date in that week - 

Fiscal week represented as max date in the week -   { FIXED [Fiscal Week] : MAX([Date])}

To select the last 4 weeks - 

Calculation9 - [Fiscal week represented as max date in the week ] > DATEADD('week', -[Last N days_KPI], TODAY())

To eliminate the last week if it is not complete -  

Max Week- 

if { FIXED ([Fiscal Week]) : COUNTD([Date])} = 7 

and 

[Fiscal week represented as max date in the week ] < {MAX([Fiscal week represented as max date in the week ])} THEN 'No' 

else 'Yes' 

end

Wanted to understand if the above is correct and Is there an easier and performant way to achieve this calculation. 

Regards,

Rishi Saka