Adding working days to a date in DAX calculated column - Unplugged #30

These chapters are auto-generated

291Likes

18,043Views

2021Jul 31

Compare different DAX formulas to add ten working days to a date in a Power BI calculated column. Alberto explores the options using DAX Studio and query calculated columns to compare the efficiency of different approaches. Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Choosing between Date or Integer to represent dates in Power BI and Tabular

SQLBI

•

10K views 3 years ago

Adding working days to a date in DAX calculated column - Unplugged #30

Chapters View all

Introduction

Introduction

Introduction

Problem statement

Problem statement

Problem statement

Plan of action

Plan of action

Plan of action

Data

Data

Data

Algorithm

Algorithm

Algorithm

Table

Table

Table

Column

Column

Column

Columns

Columns

Columns

SQLBI

Adding working days to a date in DAX calculated column - Unplugged #30

Comments 35

Chapters

Introduction

Introduction

Introduction

Problem statement

Problem statement

Problem statement

Plan of action

Plan of action

Plan of action

Data

Data

Data

Algorithm

Algorithm

Algorithm

Table

Table

Table

Column

Column

Column

Columns

Columns

Columns

Using RankX

Using RankX

Using RankX

Recap

Recap

Recap

Example

Example

Example

Check performance

Check performance

Check performance

Description

Chapters View all

SQLBI

Transcript

Choosing between Date or Integer to represent dates in Power BI and Tabular

Chapters

Chapters