How do I calculate working days inside of the query of a table with M?

[Anonymous]

I want to calculate the number of working days between the dates in two columns using M language. Nothing crazy. But I want to do it on one table, not use a date table and then create a calculated column in DAX.

I understand how to check if a date is a working day, but not how to create a calculation in M for subtracting it:

if(WEEKDAY('Date'[Date],2)<6,"TRUE","FALSE")

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file (see attachment) for you, please check whether that is what you want.

In addition, you can refer the following blog to achieve it.

Calculate Workdays Between Two Dates In Power BI

Best Regards

[amitchandak]

@Anonymous , refer to this old blog

https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/