Power Query Custom Column Calculation

Hello Everyone,

I am having weekly data in attached sheet with column ("Report Date" to "Completed Week") which i have imported in Power BI.

Now, i have to develop custom column "In Prior Weeks Schedule?" and "Completed on Schedule?" in Power BI's power query.

(Logic is as explained by using excel formulas below for the calculation).

We have to compare each WO in current reporting week with last reporting week.

Is there any way to achive this?

In Prior Weeks Schedule? =IF(

SUMIFS([WO'#],
[BU],[@BU],
[WO'#],[@[WO'#]],
[Report Week],[@[Report Week]]-1,
[Schedule Week],[@[Report Week]]-1)

=[@[WO'#]],1,0)

Completed on Schedule=IF(

AND([@[In Prior Weeks Scheudle?]],
[@[Completed Week]]=[@[Report Week]]-1),1,0)