Counting consecutive days with sales - Unplugged #47

These chapters are auto-generated

Another student's question, another video: how to count how many consecutive days have sales? See how to solve the problem step-by-step! Download sample file: https://www.sqlbi.com/tv/counting-con... Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Follow along using the transcript.

Counting consecutive days with sales - Unplugged #47

Chapters View all

Introduction

Introduction

Introduction

Question

Question

Question

Example

Example

Example

Algorithm

Algorithm

Algorithm

Coding

Coding

Coding

Conclusion

Conclusion

Conclusion

SQLBI

Counting consecutive days with sales - Unplugged #47

Comments 30

Chapters

Introduction

Introduction

Introduction

Question

Question

Question

Example

Example

Example

Algorithm

Algorithm

Algorithm

Coding

Coding

Coding

Conclusion

Conclusion

Conclusion

Description

Chapters View all

Introduction

Introduction

Introduction

Question

Question

Question

Example

Example

Example

Algorithm

Algorithm

Algorithm

SQLBI

Transcript

Consecutive days with no sales - Unplugged #18

Using ALLEXCEPT vs ALL VALUES

This is how I actually clean data using Power Query

Understanding context transition

Consecutive User Logins - SQL Interview Query 17 | SQL Problem Level "MEDIUM"

DAX Fridays #215: Previous row in DAX non-accumulated values

When to use KEEPFILTERS over iterators

Using RELATED and RELATEDTABLE in DAX

Differences between GROUPBY and SUMMARIZE

Calculate Growth From Previous Non Consecutive Date

Variations on like for like comparison - Unplugged #45

Perform a lag and lead operation in DAX with OFFSET window function

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

Optimizing SUMMARIZE by using ADDCOLUMNS - Unplugged #40

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

Custom Comparer Function for Table.Group in Power Query M

Data Modeling: One Big Table vs Kimball vs Relational for data engineers

Introducing RANK window function in DAX

Power Query Running Count Based on Row Condition – Excel Magic Trick 1588

Propagating filters using TREATAS in DAX

Chapters

Chapters