various shenanigans.

DAX: Add Business Days to Date

DAX: Add Business Days to Date

DAX calculated column code to add business days or network days to a date. VAR __Date = IF(Table1[StartDate] <> BLANK(), Table1[StartDate], date(2000, 1, 1)) // Days to Add; in my use case, the # of days was dependent on a category value. You can just set this a specific number […]

Close Bitnami banner
Bitnami