https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/2022-Week-44-Power-BI-Customer-Lifetime-Value/m-p/2878963#M8633 <P>This week, our challenge is to calculate customer lifetime value by quarter using DAX.&nbsp; This is an advanced challenge so buckle up!</P><P>As I was working on my challenge for week 44, I stumbled upon the drafted challenge for Tableau on the same week.&nbsp; The Tableau challenge was... you guessed it... developing a chart showing customer lifetime value by quarter.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Big thanks to Luke Stanke for the initial idea and not minding that we steal it for this challenge!</P><P>&nbsp;</P><P><STRONG>NOTE:</STRONG><SPAN>&nbsp;</SPAN>Datasets for Tableau and Power BI are slightly different so don't aim to match the Tableau numbers</P><P><SPAN class="reportid hidden">eyJrIjoiYjgyNzg1YTAtYTQzNi00NDNmLTg2ODktNmQ4YTU2MGI5NjJlIiwidCI6IjcxMjYwYjVhLTY3YTgtNDU3Yi05YzhjLThkNDM3ODgxOTgzMyIsImMiOjZ9&amp;pageName=ReportSection</SPAN></P> Wed, 02 Nov 2022 05:45:32 GMT NerdyWithData 2022-11-02T05:45:32Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/2022-Week-44-Power-BI-Customer-Lifetime-Value/m-p/2878963#M8633 <P>This week, our challenge is to calculate customer lifetime value by quarter using DAX.&nbsp; This is an advanced challenge so buckle up!</P><P>As I was working on my challenge for week 44, I stumbled upon the drafted challenge for Tableau on the same week.&nbsp; The Tableau challenge was... you guessed it... developing a chart showing customer lifetime value by quarter.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Big thanks to Luke Stanke for the initial idea and not minding that we steal it for this challenge!</P><P>&nbsp;</P><P><STRONG>NOTE:</STRONG><SPAN>&nbsp;</SPAN>Datasets for Tableau and Power BI are slightly different so don't aim to match the Tableau numbers</P><P><SPAN class="reportid hidden">eyJrIjoiYjgyNzg1YTAtYTQzNi00NDNmLTg2ODktNmQ4YTU2MGI5NjJlIiwidCI6IjcxMjYwYjVhLTY3YTgtNDU3Yi05YzhjLThkNDM3ODgxOTgzMyIsImMiOjZ9&amp;pageName=ReportSection</SPAN></P> Wed, 02 Nov 2022 05:45:32 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/2022-Week-44-Power-BI-Customer-Lifetime-Value/m-p/2878963#M8633 NerdyWithData 2022-11-02T05:45:32Z