Forum Discussion

Mohsen_2020's avatar
Mohsen_2020
Helper III
5 years ago
Solved

Create a measure calculating Working Days

Dear Team,  Ashish_Mathur  I need your support to creeate a measure calculating number of working days knowing that Saturday & Friday days are off, i mean to exculude both "Friday & Satureday" from...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi Mohsen_2020 ,

open your data in Power Query and add a new column that holds the information 'Is Workingday'. 1 is workingday, 0 isn't workingday. Use the following M-code (4 = Friday, 5 = Saturday):

 

= Table.AddColumn(#"Changed Type", "Is Workingday", each if Date.DayOfWeek([Call Time]) = 4 or Date.DayOfWeek([Call Time]) = 5 then 0 else 1, Int64.Type)

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)