In this video, Sam is going to show how you can calculate the days since a customer’s last purchase using DAX in Power BI. Based on this, we can get actionable insights to encourage retention among our customers. Lots of great actions can be initiated from such an insight.
***** Video Details *****
00:00 Introduction
01:22 Finding out the date of last purchase
02:25 Working out the last purchase date
03:19 Determining the days since last purchase
05:58 Using a threshold
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial
- How To Calculate Days Since Last Purchase Using DAX In Power BI [2022 Update] ( Download)
- Calculate Days Since Last Purchase Using DAX In Power BI ( Download)
- Days Since Last Purchase Calculation using Dax in Power BI || Power BI Tasks 2023 || ( Download)
- Interview Question | Last Purchase Date | Advanced DAX | Power BI ( Download)
- Use Duration.Days and LocalNow() for # Days until/since a Date in Power BI using Power Query Editor ( Download)
- Get Most recent/Max Date value in PowerBI using DAX | MiTutorials ( Download)
- Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX [2023 Update] ( Download)
- Power BI - Calculate difference in days between two dates ( Download)
- Get Max Date for a Particular Category/Group using Measure in PowerBi | MiTutorials ( Download)
- Last N Days calculation in Power BI using Variables - 58 (Power BI Training) ( Download)
- Flexibility with Days Since calculations in Power BI ( Download)
- How to find the last transaction date using MAX formula | How to find | POWER BI - DAX Calculation ( Download)
- Power BI Customer Analysis(Days Since LastOrder) ( Download)
- Interview Question | Last 7 days Sales | Power BI | DAX ( Download)
- How to Calculate Last N Days Value or Future N values in Power BI Using Dax Function DateADD ( Download)
