NetWorkDays
The Scenario Power Query offers some date functions but none resembles Excel’s NETWORKDAYS to calculate the number of working days between two dates. In this…
Category: Date – Time
Dynamic Calendar Table
The Scenario When you are facing a scenario where you need to create a Dynamic Calendar Table (or Date Dimension Table), we take in consideration…
