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

208Likes

8,425Views

2021Aug 14

Modify the formula of an article answering a reader question: How to compute the last 6 months of transactions using the last transaction date of each customer, using a range of dates that is different for every customer. In the video, we see different versions of the same formula, adapting the code to non-additive measures if necessary. Download the sample file here: https://www.sqlbi.com/tv/analyzing-th... Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Compute a Different Date for each Customer

8:37

Create a Table Containing the Customer and the Maximum Sales

24:52

Conclusion

30:33

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Exploring attribute hierarchies in Power BI and Analysis Services - Unplugged #31

SQLBI

•

5.2K views 3 years ago

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

SQLBI

•

10K views 3 years ago

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

Key moments

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Conclusion

Conclusion

Conclusion

SQLBI

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

Comments 12

Key moments

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Conclusion

Conclusion

Conclusion

Description

Key moments

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Conclusion

Conclusion

Conclusion

SQLBI

Transcript

Exploring attribute hierarchies in Power BI and Analysis Services - Unplugged #31

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

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

Key moments View all

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Conclusion

Conclusion

Conclusion

SQLBI

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

Comments 12

Key moments

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Conclusion

Conclusion

Conclusion

Description

Key moments View all

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Compute a Different Date for each Customer

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Create a Table Containing the Customer and the Maximum Sales

Conclusion

Conclusion

Conclusion

SQLBI

Transcript

Exploring attribute hierarchies in Power BI and Analysis Services - Unplugged #31

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

Key moments

Key moments