Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX

In this example I will show you how you can calculated the difference in days between purchases in Power BI using DAX formulas.

There is some advanced logic here using the FILTER and CALCULATE functions.

This is a great insights if you want to work out trends in customer behaviour or would like the target marketing campaigns more specifically to relevant customers.

Enjoy working through this tutorial.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.