Translate DAX formular into PQ M

[RichterSeb]

Hello,

I need your help with tranlsating DAX into M.

I have the Dax code already but would like to have it in PowerQuery for other calculations.

DimDateTable -> already got it in PQ

CountOfInstalledBase = var _filter=COUNTROWS(FILTER('EquipmentsSO',[DimDate]>=[Warranty period (start)].[Date]))

return IF(_filter=BLANK(),1,_filter)

CountOfToolsInWarranty = var _filter=COUNTROWS(FILTER('EquipmentsSO',[DimDate]>=[Warranty period (start)]&&[DimDate]<=[Warranty period (end)].[Date]))

return IF(_filter=BLANK(),0,_filter)

This is the table I got in DAX.

I would appreciate any help. Thanks in advance.

Regards

Sebastian