Help converting VBA into Power Query

[pmbassan]

Hey guys!
I use this VBA since 2018, but now I want to use it in Power BI. Can someone please help me converting this from VBA to DAX, so I can use it?
The VBA calculate the period between the two dates, only considering working hours (8h30-18h30), working days, discarding weekends and holidays (holidays in Brazil are in the second page, named "Feriados").

The example is in this file: Calculadora nova_V3_Correção_Jan_2018.xlsm

 

[jdellasala]

That code is very long and doesn't seem to do anything. It would be better if you used XL2BB and copied Before and After samples (NOT screenshots!).