This week, our challenge is to calculate customer lifetime value by quarter using DAX. This is an advanced challenge so buckle up!
As I was working on my challenge for week 44, I stumbled upon the drafted challenge for Tableau on the same week. The Tableau challenge was... you guessed it... developing a chart showing customer lifetime value by quarter.
I began to think about the differences in how I would address this problem in Tableau and Power BI and decided it would be fun to tackle this for our challenge as well.
Big thanks to Luke Stanke for the initial idea and not minding that we steal it for this challenge!
NOTE: Datasets for Tableau and Power BI are slightly different so don't aim to match the Tableau numbers
eyJrIjoiYjgyNzg1YTAtYTQzNi00NDNmLTg2ODktNmQ4YTU2MGI5NjJlIiwidCI6IjcxMjYwYjVhLTY3YTgtNDU3Yi05YzhjLThkNDM3ODgxOTgzMyIsImMiOjZ9&pageName=ReportSection
