Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Working below a DAX formula’s granularity

120K subscribers

21K views 4 years ago

How to control the result of a DAX measure used in a report with granularity below the granularity supported by the formula. Article and download: https://sql.bi/661463/?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

...more

...more

These chapters are auto-generated

Introduction

Removing filters

Context transition

All except

Days

Results

Working below a DAX formula’s granularity

626Likes

21,260Views

2021Jan 26

How to control the result of a DAX measure used in a report with granularity below the granularity supported by the formula. Article and download: https://sql.bi/661463/?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Introduction

Removing filters

Context transition

All except

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Working below a DAX formula’s granularity