No video

How To Calculate Days Since Last Purchase Using DAX In Power BI [2022 Update]

  Рет қаралды 7,636

Enterprise DNA

Enterprise DNA

Күн бұрын

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.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - Power BI Resources - www.enterprised...
FREE - 60 Page DAX Reference Guide Download - www.enterprise...
Enterprise DNA Membership - www.enterprise...
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - www.enterprise...
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

Пікірлер: 7
@EnterpriseDNA
@EnterpriseDNA Жыл бұрын
Check out our FREE courses: bit.ly/3N00AJw
@sujaymallesh
@sujaymallesh Жыл бұрын
Very useful thanks
@arbazahmad7177
@arbazahmad7177 Жыл бұрын
Great explanation.. 👍
@balaji_906
@balaji_906 Жыл бұрын
Top quality content as always 👍
@seetharamesh3856
@seetharamesh3856 Жыл бұрын
I have a seperate table for inventory and sales. In both tables, for particular item code there are different order date and for particular item code there are different purchase date. I need to create a column quantity, which displays there are these much quantities sold on the same date. And I need to calculate the frequency of days the order has been sold. Kindly help me with this
@khanhnguyenduy1089
@khanhnguyenduy1089 Жыл бұрын
Lastdate not work with dumplicate date when a customer Purchase two times in one order date. What about this case?
@EnterpriseDNA
@EnterpriseDNA Жыл бұрын
Hi Khánh, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. In that case, although order date is same for both the transactions, order number will be different. So, you'll be required to write a condition wherein latest Order Date and Order Number is considered. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! If you haven't yet, you can subscribe to our KZfaq channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 54 М.
哈莉奎因以为小丑不爱她了#joker #cosplay #Harriet Quinn
00:22
佐助与鸣人
Рет қаралды 10 МЛН
Ouch.. 🤕
00:30
Celine & Michiel
Рет қаралды 36 МЛН
艾莎撒娇得到王子的原谅#艾莎
00:24
在逃的公主
Рет қаралды 42 МЛН
Average Days Between Orders (DAX Tutorial)
6:54
KnowledgeBank by obviEnce
Рет қаралды 7 М.
Power BI Dashboard | Challenge 2h pour créer un tableau de bord
10:10
Alexandre STEVENS
Рет қаралды 54 М.
Create Automatic Forecasts From Historic Data in Power BI using DAX
10:26
Counting consecutive days with sales - Unplugged #47
13:52
Customer Retention in Power BI   DAX Measures
10:10
RADACAD
Рет қаралды 29 М.
Advanced Customer Analytics with Power BI - Sam Fischer
1:19:28
Apex Insights
Рет қаралды 44 М.
Exploring the SEMANTIC MODEL in Power BI
27:30
How to Power BI
Рет қаралды 122 М.