Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
11-01-2022 22:45 PM
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