Канал: SQLBI

Introducing the 3-30-300 rule for better reports

Introducing the 3-30-300 rule for better reports

Understanding apply semantics for window functions in DAX

Understanding apply semantics for window functions in DAX

Writing DAX with ChatGPT-4o - Unplugged #58

Writing DAX with ChatGPT-4o - Unplugged #58

Best practices for using KEEPFILTERS in DAX

Best practices for using KEEPFILTERS in DAX

Comparing cumulative metrics for events with different start dates

Comparing cumulative metrics for events with different start dates

Using EXPAND and COLLAPSE in visual calculations

Using EXPAND and COLLAPSE in visual calculations

Use scatterplots to find details in Power BI reports

Use scatterplots to find details in Power BI reports

Revolutionizing Power BI: Introducing the Ultimate Formula Language

Revolutionizing Power BI: Introducing the Ultimate Formula Language

Introducing EXPAND and COLLAPSE for visual calculations in Power BI

Introducing EXPAND and COLLAPSE for visual calculations in Power BI

Vpax Obfuscator and DAX Optimizer - Unplugged #57

Vpax Obfuscator and DAX Optimizer - Unplugged #57

SqlBits 2024 - Day 1

SqlBits 2024 - Day 1

Preparation for the training day @SqlBits 2024

Preparation for the training day @SqlBits 2024

Follow me at SqlBits and Fabric Conference

Follow me at SqlBits and Fabric Conference

Introducing VISUAL SHAPE for visual calculations in Power BI

Introducing VISUAL SHAPE for visual calculations in Power BI

DAX Optimizer overview - Unplugged #56

DAX Optimizer overview - Unplugged #56

Improve data labels with format strings

Improve data labels with format strings

Introducing SQLBI Days

Introducing SQLBI Days

DAX limitations with row level security RLS

DAX limitations with row level security RLS

Optimizing time intelligence in DirectQuery

Optimizing time intelligence in DirectQuery

Differences between DATEADD and PARALLELPERIOD in DAX

Differences between DATEADD and PARALLELPERIOD in DAX

Using tuple syntax in DAX expressions

Using tuple syntax in DAX expressions

Circular dependencies and relationships - Unplugged #55

Circular dependencies and relationships - Unplugged #55

Replacing relationships with join functions in DAX

Replacing relationships with join functions in DAX

What happened in DAX in 2023

What happened in DAX in 2023

Using join functions in DAX

Using join functions in DAX

Preparing a data model for Sankey Charts in Power BI

Preparing a data model for Sankey Charts in Power BI

Computing accurate percentages with row level security in Power BI

Computing accurate percentages with row level security in Power BI

Unboxing DAX Query View in Power BI - Unplugged #54

Unboxing DAX Query View in Power BI - Unplugged #54

Computing MTD, QTD, YTD in Power BI for the current period

Computing MTD, QTD, YTD in Power BI for the current period

Optimizing callbacks in a SUMX iterator

Optimizing callbacks in a SUMX iterator

Using field parameters and calculation groups for conditional formatting

Using field parameters and calculation groups for conditional formatting

Finding products without sales by using DAX

Finding products without sales by using DAX

SqlBits 2024 Unveiled

SqlBits 2024 Unveiled

Using DAX to control a chart range in Power BI

Using DAX to control a chart range in Power BI

Managing hierarchical organizations in Power BI security roles

Managing hierarchical organizations in Power BI security roles

Differences between GROUPBY and SUMMARIZE

Differences between GROUPBY and SUMMARIZE

Comparing different school terms in Power BI

Comparing different school terms in Power BI

Filtering calculation items in a slicer

Filtering calculation items in a slicer

Reading active Power BI security roles in DAX

Reading active Power BI security roles in DAX

Introducing RANK window function in DAX

Introducing RANK window function in DAX

The Making of Optimizing DAX Second Edition - Unplugged #53

The Making of Optimizing DAX Second Edition - Unplugged #53

Implementing linear regression in Power BI

Implementing linear regression in Power BI

Compare previous date with sales - Unplugged #52

Compare previous date with sales - Unplugged #52

Introducing dynamic format strings for DAX measures

Introducing dynamic format strings for DAX measures

Optimizing text search in DAX

Optimizing text search in DAX

Optimizing DAX Second Edition - Interview with Alberto Ferrari and Marco Russo

Optimizing DAX Second Edition - Interview with Alberto Ferrari and Marco Russo

Optimizing DAX Second Edition Video Course

Optimizing DAX Second Edition Video Course

Rounding errors with different data types in DAX

Rounding errors with different data types in DAX

Optimizing SWITCH on slicer selection with Group By Columns

Optimizing SWITCH on slicer selection with Group By Columns

Displaying only child values in parent-child - Unplugged #46

Displaying only child values in parent-child - Unplugged #46

Optimizing fusion optimization for DAX measures

Optimizing fusion optimization for DAX measures

DAX Studio Server FE Benchmark - Unplugged #51

DAX Studio Server FE Benchmark - Unplugged #51

Writing DAX with ChatGPT-4 - Unplugged #50

Writing DAX with ChatGPT-4 - Unplugged #50

Understanding Group By Columns in Power BI

Understanding Group By Columns in Power BI

DAX Studio Timeline in Server Timings - Unplugged #49

DAX Studio Timeline in Server Timings - Unplugged #49

Using calculation groups or many to many relationships for time intelligence selection

Using calculation groups or many to many relationships for time intelligence selection

Show the initial balance for any date selection in Power BI - Unplugged #48

Show the initial balance for any date selection in Power BI - Unplugged #48

Blank row and limited relationships

Blank row and limited relationships

Counting consecutive days with sales - Unplugged #47

Counting consecutive days with sales - Unplugged #47

Introducing window functions in DAX

Introducing window functions in DAX

Debugging DAX measures in Power BI

Debugging DAX measures in Power BI

Variations on like for like comparison - Unplugged #45

Variations on like for like comparison - Unplugged #45

What happened in DAX in 2022

What happened in DAX in 2022

Many-to-Many Relationships - The Whiteboard #12

Many-to-Many Relationships - The Whiteboard #12

ERROR - DAX Guide

ERROR - DAX Guide

Custom Date Templates with Bravo for Power BI

Custom Date Templates with Bravo for Power BI

One-to-One Relationships - The Whiteboard #11

One-to-One Relationships - The Whiteboard #11

USERNAME, USEROBJECTID, USERPRINCIPALNAME, CUSTOMDATA, USERCULTURE - DAX Guide

USERNAME, USEROBJECTID, USERPRINCIPALNAME, CUSTOMDATA, USERCULTURE - DAX Guide

Solving errors in CALCULATE filter arguments

Solving errors in CALCULATE filter arguments

Regular and Limited Relationships - The Whiteboard #10

Regular and Limited Relationships - The Whiteboard #10

ISSUBTOTAL - DAX Guide

ISSUBTOTAL - DAX Guide

Welcome to SQLBI+

Welcome to SQLBI+

Filters based on content of other tables in Power BI - Unplugged #44

Filters based on content of other tables in Power BI - Unplugged #44

Invalid Relationships - The Whiteboard #09

Invalid Relationships - The Whiteboard #09

SELECTEDMEASUREFORMATSTRING - DAX Guide

SELECTEDMEASUREFORMATSTRING - DAX Guide

Introducing horizontal fusion in DAX

Introducing horizontal fusion in DAX

Bravo for Power BI v1.0 Launch

Bravo for Power BI v1.0 Launch

SELECTEDMEASURENAME - DAX Guide

SELECTEDMEASURENAME - DAX Guide

Why Power BI totals might seem wrong

Why Power BI totals might seem wrong

One-to-Many Relationships - The Whiteboard #08

One-to-Many Relationships - The Whiteboard #08

ISSELECTEDMEASURE - DAX Guide

ISSELECTEDMEASURE - DAX Guide

Using cross highlight with order and delivery date in Power BI

Using cross highlight with order and delivery date in Power BI

Storage Engine (VertiPaq) - The Whiteboard #07

Storage Engine (VertiPaq) - The Whiteboard #07

SELECTEDMEASURE - DAX Guide

SELECTEDMEASURE - DAX Guide

Introducing RANKX in DAX

Introducing RANKX in DAX

Formula Engine - The Whiteboard #06

Formula Engine - The Whiteboard #06

PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH - DAX Guide

PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH - DAX Guide

Introducing ALLSELECTED in DAX

Introducing ALLSELECTED in DAX

Variables - The Whiteboard #05

Variables - The Whiteboard #05

DEFINE TABLE - DAX Guide

DEFINE TABLE - DAX Guide

Using RELATED and RELATEDTABLE in DAX

Using RELATED and RELATEDTABLE in DAX

Expanded Table - The Whiteboard #04

Expanded Table - The Whiteboard #04

DAX Studio 3 announcement

DAX Studio 3 announcement

DEFINE COLUMN - DAX Guide

DEFINE COLUMN - DAX Guide

Computing sales made to customers before and after a period

Computing sales made to customers before and after a period

Context Transition - The Whiteboard #03

Context Transition - The Whiteboard #03

DEFINE MEASURE - DAX Guide

DEFINE MEASURE - DAX Guide

Variables in DAX

Variables in DAX

Row Context - The Whiteboard #02

Row Context - The Whiteboard #02

VAR - DAX Guide

VAR - DAX Guide

Rolling average with working days in DAX

Rolling average with working days in DAX

Filter Context - The Whiteboard #01

Filter Context - The Whiteboard #01

EVALUATE, ORDER BY - DAX Guide

EVALUATE, ORDER BY - DAX Guide

Hiding measures by using object level security in Power BI

Hiding measures by using object level security in Power BI

Understanding the optimization of SWITCH

Understanding the optimization of SWITCH

CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR - DAX Guide

CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR - DAX Guide

STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR - DAX Guide

STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR - DAX Guide

OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR - DAX Guide

OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR - DAX Guide

Using KEEPFILTERS in DAX

Using KEEPFILTERS in DAX

NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSYEAR - DAX Guide

NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSYEAR - DAX Guide

FIRSTNONBLANK, LASTNONBLANK, FIRSTNONBLANKVALUE, LASTNONBLANKVALUE - DAX Guide

FIRSTNONBLANK, LASTNONBLANK, FIRSTNONBLANKVALUE, LASTNONBLANKVALUE - DAX Guide

DATESINPERIOD - DAX Guide

DATESINPERIOD - DAX Guide

FIRSTDATE, LASTDATE - DAX Guide

FIRSTDATE, LASTDATE - DAX Guide

Fields parameters in Power BI

Fields parameters in Power BI

PARALLELPERIOD - DAX Guide

PARALLELPERIOD - DAX Guide

DATEADD, SAMEPERIODLASTYEAR - DAX Guide

DATEADD, SAMEPERIODLASTYEAR - DAX Guide

DATESBETWEEN - DAX Guide

DATESBETWEEN - DAX Guide

DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD - DAX Guide

DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD - DAX Guide

Understanding context transition

Understanding context transition

PERMUT - DAX Guide

PERMUT - DAX Guide

NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV - DAX Guide

NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV - DAX Guide

CONFIDENCE.NORM, CONFIDENCE.T - DAX Guide

CONFIDENCE.NORM, CONFIDENCE.T - DAX Guide

COMBIN, COMBINA - DAX Guide

COMBIN, COMBINA - DAX Guide

Introducing CALCULATE in DAX

Introducing CALCULATE in DAX

BETA.DIST, BETA.INV - DAX Guide

BETA.DIST, BETA.INV - DAX Guide

PERCENTILE.EXC, PERCENTILE.INC, PERCENTILEX.EXC, PERCENTILEX.INC - DAX Guide

PERCENTILE.EXC, PERCENTILE.INC, PERCENTILEX.EXC, PERCENTILEX.INC - DAX Guide

CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT - DAX Guide

CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT - DAX Guide

RANK.EQ - DAX Guide

RANK.EQ - DAX Guide

50,000 followers!

50,000 followers!

Filter Context in DAX

Filter Context in DAX

POISSON.DIST - DAX Guide

POISSON.DIST - DAX Guide

RANKX - DAX Guide

RANKX - DAX Guide

SAMPLE - DAX Guide

SAMPLE - DAX Guide

ISAFTER, ISONORAFTER - DAX Guide

ISAFTER, ISONORAFTER - DAX Guide

Row Context in DAX

Row Context in DAX

Introducing Bravo for Power BI

Introducing Bravo for Power BI

T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T - DAX Guide

T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T - DAX Guide

ISEVEN, ISODD - DAX Guide

ISEVEN, ISODD - DAX Guide

STDEV.P, STDEV.S, STDEVX.P, STDEVX.S - DAX Guide

STDEV.P, STDEV.S, STDEVX.P, STDEVX.S - DAX Guide

ISERROR - DAX Guide

ISERROR - DAX Guide

How to return BLANK instead of zero

How to return BLANK instead of zero

VAR.P, VAR.S, VARX.P, VARX.S - DAX Guide

VAR.P, VAR.S, VARX.P, VARX.S - DAX Guide

DAX by examples

DAX by examples

BLANK - DAX Guide

BLANK - DAX Guide

RAND, RANDBETWEEN - DAX Guide

RAND, RANDBETWEEN - DAX Guide

ISFILTERED, ISCROSSFILTERED - DAX Guide

ISFILTERED, ISCROSSFILTERED - DAX Guide

SQRTPI, PI - DAX Guide

SQRTPI, PI - DAX Guide

Displaying measures as percentages in Power BI charts - Unplugged #43

Displaying measures as percentages in Power BI charts - Unplugged #43

Understanding the IN operator in DAX

Understanding the IN operator in DAX

ISINSCOPE - DAX Guide

ISINSCOPE - DAX Guide

SIN, COS, ASIN, ACOS, TAN, ATAN, COT, ACOT - DAX Guide

SIN, COS, ASIN, ACOS, TAN, ATAN, COT, ACOT - DAX Guide

ISBLANK - DAX Guide

ISBLANK - DAX Guide

Differences between INT and CONVERT in DAX

Differences between INT and CONVERT in DAX

RADIANS, DEGREES - DAX Guide

RADIANS, DEGREES - DAX Guide

Analyzing related geography attributes in different tables in Power BI - Unplugged #42

Analyzing related geography attributes in different tables in Power BI - Unplugged #42

ISEMPTY - DAX Guide

ISEMPTY - DAX Guide

ROUND, ROUNDDOWN, ROUNDUP, TRUNC - DAX Guide

ROUND, ROUNDDOWN, ROUNDUP, TRUNC - DAX Guide

ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT - DAX Guide

ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT - DAX Guide

Scripting syntax for DAX calculation groups

Scripting syntax for DAX calculation groups

FLOOR, MROUND, CEILING, ISO CEILING - DAX Guide

FLOOR, MROUND, CEILING, ISO CEILING - DAX Guide

Performance of sparklines in Power BI - Unplugged #41

Performance of sparklines in Power BI - Unplugged #41

EXPON.DIST - DAX Guide

EXPON.DIST - DAX Guide

GCD, LCM - DAX Guide

GCD, LCM - DAX Guide

GEOMEAN, GEOMEANX - DAX Guide

GEOMEAN, GEOMEANX - DAX Guide

Using ALLSELECTED in composite models

Using ALLSELECTED in composite models

SQRT, POWER - DAX Guide

SQRT, POWER - DAX Guide

Optimizing SUMMARIZE by using ADDCOLUMNS - Unplugged #40

Optimizing SUMMARIZE by using ADDCOLUMNS - Unplugged #40

MEDIAN, MEDIANX - DAX Guide

MEDIAN, MEDIANX - DAX Guide

SINH, COSH, ASINH, ACOSH, TANH, ATANH, COTH, ACOTH - DAX Guide

SINH, COSH, ASINH, ACOSH, TANH, ATANH, COTH, ACOTH - DAX Guide

LN, LOG, LOG10, EXP - DAX Guide

LN, LOG, LOG10, EXP - DAX Guide

Understanding the interactions between composite models and calculation groups

Understanding the interactions between composite models and calculation groups

What happened in the DAX world in 2021

What happened in the DAX world in 2021

ODD, EVEN - DAX Guide

ODD, EVEN - DAX Guide

ABS, SIGN - DAX Guide

ABS, SIGN - DAX Guide

EARLIER, EARLIEST - DAX Guide

EARLIER, EARLIEST - DAX Guide

Wholesale and retail execution in composite models

Wholesale and retail execution in composite models

CROSSFILTER - DAX Guide

CROSSFILTER - DAX Guide

Answering questions: another option for many to many relationships in Power BI - Unplugged #39

Answering questions: another option for many to many relationships in Power BI - Unplugged #39

USERELATIONSHIP - DAX Guide

USERELATIONSHIP - DAX Guide

RELATED, RELATEDTABLE - DAX Guide

RELATED, RELATEDTABLE - DAX Guide

FACT - DAX Guide

FACT - DAX Guide

Different options to model many to many relationships in Power BI and Tabular

Different options to model many to many relationships in Power BI and Tabular

CONVERT, INT, CURRENCY - DAX Guide

CONVERT, INT, CURRENCY - DAX Guide

Answering questions: running total and last dates within selection - Unplugged #38

Answering questions: running total and last dates within selection - Unplugged #38

MOD, QUOTIENT - DAX Guide

MOD, QUOTIENT - DAX Guide

DIVIDE - DAX Guide

DIVIDE - DAX Guide

Variant - DAX Guide

Variant - DAX Guide

Analyzing the parallelism of storage engine operations in DAX Studio

Analyzing the parallelism of storage engine operations in DAX Studio

HASONEFILTER - DAX Guide

HASONEFILTER - DAX Guide

CONTAINS, CONTAINSROW - DAX Guide

CONTAINS, CONTAINSROW - DAX Guide

HASONEVALUE - DAX Guide

HASONEVALUE - DAX Guide

Differences between GENERATE and CROSSJOIN solving business scenarios - Unplugged #37

Differences between GENERATE and CROSSJOIN solving business scenarios - Unplugged #37

CONTAINSSTRING, CONTAINSSTRINGEXACT - DAX Guide

CONTAINSSTRING, CONTAINSSTRINGEXACT - DAX Guide

How to enable the Single Value option in a Power BI slicer

How to enable the Single Value option in a Power BI slicer

AND, OR, NOT, TRUE, FALSE - DAX Guide

AND, OR, NOT, TRUE, FALSE - DAX Guide

IFERROR - DAX Guide

IFERROR - DAX Guide

COALESCE - DAX Guide

COALESCE - DAX Guide

SWITCH - DAX Guide

SWITCH - DAX Guide

IF - DAX Guide

IF - DAX Guide

Creating real time dashboards in Power BI with push datasets

Creating real time dashboards in Power BI with push datasets