Explaining unexpected results with DAX Time Intelligence functions - Unplugged #17

196Likes

5,605Views

2021May 1

Why the standard DAX time intelligence functions might return unexpected results? Discover how DATEADD and SAMEPERIODLASTYEAR work under the hood! Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Explaining unexpected results with DAX Time Intelligence functions - Unplugged #17

SQLBI

Explaining unexpected results with DAX Time Intelligence functions - Unplugged #17

Comments 12

Description

SQLBI

Transcript

Understanding data lineage in DAX

Understanding Power BI Time Intelligence DAX Functions with Real Time Examples

When to use KEEPFILTERS over iterators

Unexpected DAX results using SUMX

Consecutive days with no sales - Unplugged #18

Time Intelligence calculations with Power BI | Community Webinars

Using ALLEXCEPT vs ALL VALUES

Time Intelligence in Power BI

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

Displaying the distribution of distance between transactions - Unplugged #19

Business Analyst or Data Analyst? | Salary, Job, Skills

Creating custom groups using calculation items - Unplugged #24

My number 1 trick for TIME INTELLIGENCE | Power BI DAX

SAMEPERIODLASTYEAR vs PARALLELPERIOD vs DATEADD // DAX Basics // Beginners Guide to Power BI in 2022

I Tried To Make Something In America (The Smarter Scrubber Experiment) - Smarter Every Day 308

Musk-Trump Feud Goes Nuclear | DHS's 22-Year-Old Terrorism Chief

Analyzing the last 6 months of sales from the last transaction of each customer - Unplugged #32

Types Of Time Intelligence Functions - (1.15) Ultimate Beginners Guide to DAX 2019

Still Think Russia is Winning? WATCH THIS Before You Speak Again

TopPercent in DAX - Unplugged #8