Trending December 2023 # Last Purchase Date In Power Bi: When Did Your Customers Make Their Last Purchase? # Suggested January 2024 # Top 17 Popular

You are reading the article Last Purchase Date In Power Bi: When Did Your Customers Make Their Last Purchase? updated in December 2023 on the website We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 Last Purchase Date In Power Bi: When Did Your Customers Make Their Last Purchase?

It’s the goal of every organization to see their business become successful. That said, understanding customer behavior deeply is one of the elements you can leverage for increased business success. One way to do this is by knowing your customers’ last purchase date in Power BI. You may watch the full video of this tutorial at the bottom of this blog.

In this blog post, I am going to demonstrate how you can work out how many days it has been since a customer last purchased from you.

This is very important from a sales, marketing, and promotional point of view because gaining such insight can help you strategize around your marketing initiatives.

For instance, if a customer buys from you every two weeks, you can use email marketing strategies to send offers at times which will most likely lead to a sale and ultimately increase your revenue. 

If you have a CRM system in place, you would want to know if a customer is actively buying from you. They might have gone to a competitor or they might be considering taking the business elsewhere. You want to know these things in real-time.

By understanding this metric and learning about your customer behavior, you are likely to make better decisions that will ultimately improve the sales and services you’ll be offering to your client base.

I’ll show you how to analytically think about this in Power BI. Plus, how to solve it, implement the right DAX formula, and then visualize it in a compelling way.

Before we proceed, let’s take a look at the underlying table. This is where we’ll get all the information we’ll need, including the Purchase Date of our customers.

The specific insight we’re going to look at is how many days since the last purchase a customer has made. We have to walk through a few steps in order to find out.

In this table, we get to see the Customer Name, Date of Last Purchase, and Days Since Last Purchase fields.

The first thing we need to do is to work out when was our customers’ last purchase. We do this by creating a new measure using this formula:

Once we apply this formula, we will see that the customers have been filtered, and all that’s left in the sales table are the dates of the customers’ last purchase.

The next thing we need to do is work out the last purchase date in Power BI for every customer. 

We can work it out by creating a new measure in Power BI using this formula: MAXX(ALL (Sales), Sales[Purchase Date]).

So for this demo data set, you’ll see that the Last Purchase Date in this particular case is January 6, 2023.

From here, we can now work out the days since the last purchase since we have the individual Last Purchase Date of each customer.

To get the Days Since Last Purchase, all we have to do is deduct the Date of Last Purchase from the Last Purchase Date. We do this by creating a measure using this formula:

If we subtract a date from a date, it will return a date format. Therefore, we use VALUE so we can turn the text value into a number.

We definitely don’t want a result that shows customers even if they did not make a purchase in Florida. The way we do that is by using logic in our model.

Another option you can use to create a new measure is by using a threshold.

Let’s say we want to have a list of customers who have breached the 300-day threshold. We can come up with a customer list by using this formula:

You can then create a chart that will showcase the customers that are above this 300-day threshold.

By coming up with formulas from the purchase date in Power BI, we can use the data we gathered from a marketing or a customer outreach perspective.

It is amazing how you can quickly branch out into these fantastic insights using Power BI. With the data you have gathered, you can create an insight and then use it to implement your marketing strategies.

This blog post shows just one way to predict customer behavior.  To learn other business analytics techniques that you can utilize, check out the module below from Enterprise DNA On-demand.

Business Analytics Series

All the best!


You're reading Last Purchase Date In Power Bi: When Did Your Customers Make Their Last Purchase?

Last Week In Tech: Did Artificial Intelligence Write This Post? Maybe.

Like it or not, artificial intelligence already plays a considerable role in your life. Maybe Facebook’s algorithm pointed you toward this article. Maybe you just switched off a Netflix movie that magically popped up in your recommendations. Maybe you’re hiding under your bed hoping that hyper-intelligent machines won’t find you. OK, that last one is an exaggeration, but maybe not by as much as you’d think. In fact, a recent Pew research survey found that more than 70 percent of people are worried about a future in “in which machines do many jobs currently done by humans.” If you’re one of those people, last week’s Google-dominated, AI-heavy tech news cycle definitely didn’t help.

Luckily, this column is still solely the product of human effort (except for autocorrect, which I still need to fix words like “occasion” that I’m seemingly incapable of learning). Here’s a rundown of last week’s biggest technology stories.

Download the latest episode the Last Week in Tech podcast!

Sony MiniDisc Player

Gadgets do not age gracefully most of the time. This is not an exception.

This week’s episode covers the highs and lows of Google’s big developers conference, as well as the latest news about net neutrality and a story about taking a bath while wearing jeans. You can listen in the player above, subscribe on SoundCloud, iTunes, or Stitcher.

Boston Dynamics robots went for a jog

Google’s AI announcements were almost entirely software-based, but the roboticists at Boston Dynamics showed off some impressive video of its Atlas robot. This time, the creation is out for a jog, which is really impressive, but after an indulgent Mother’s Day brunch, it also feels a little passive aggressive to watch that robot happily running.

The company also announced that it plans to sell its dog-like SpotMini robots starting in 2023 to companies who want to use them as security, or maybe for aspiring filmmakers who want to rip off that one episode of Black Mirror.

Elon Musk showed off a big tunnel

The boyfriend of musician Grimes has been bragging about his subterranean tunnel below LA and now it’s nearing completion. Musk says rides will be free during the testing phase of the Boring Company’s first underground tube when it starts operation later this year.

Everyone checked their Klout score one last time before the service dies

My final Klout score

Klout was like earning merit badges for using the internet only you can’t sew them onto a sash and your parents were never proud of them.

For as long as social media has existed, people have wanted to “win” at it by getting more followers and exerting more influence over the rest of the internet. Klout was a service designed to track how much influence you had across various channels and on a variety of topics and it will officially shut down on May 25th, presumably to avoid compliance with the GDPR requirements. When I signed up, Dane Cook had a really high score, if that’s any indication of where this service falls in the grand timeline of internet foolishness. My final Klout score is 62.

All new houses in California will have to come with solar panels Microsoft showed off some of its new tech at its annual Build conference

Google’s developers conference dominated the news cycle last week, but Microsoft showed off some new tech of its own at its Build conference. Check out our round-up of the important developments including a totally adorable new friendship between Amazon’s Alexa and Microsoft’s disembodied digital assistant, Cortana.

Uber shared a little more about its flying taxis

Uber Flying Taxi

“Yes, hi, please fly me to Target so I can buy some beef jerky. Thanks.”

The Uber Elevate conference happened last week and it gave us another look at Uber’s upcoming flying taxi, which it hopes to have in the skies by 2023. The electric vehicle will fly at an altitude between 1,000 and 2,000 feet, but there’s no word if the service will let you repel down on a rope to your destination like a super spy. (It probably won’t.)

There’s an important Net Neutrality vote coming up

You may have noticed some of your favorite websites nagging you to take action in the fight for Net Neutrality. That’s because Senate democrats have forced a vote on the issue that’s coming up before June 12, although it could happen this week. Get a top-level view of the issue here.

Marshall revamped its headphones

Marshall Major III headphones

You don’t need hip hand tattoos to wear these headphones.

Guitar amps are Marshall’s primary concern, but the company has had a lot of success making headphones as well. The updated version of the popular Major over-the-ear headphones comes in both wired and Bluetooth and has larger 40mm drivers to increase audio output. The wired version is just $79, while the Bluetooth model is $150, which makes them relatively affordable for this level of performance. Plus, they look very cool.

What To Think About When You Want To Purchase A Vac

There are numerous kinds of vacuums out there including upright, cylinder robot, handheld, and stick. The way a cable-free stick is made offers the most ease and freedom of movement.

They’re made small for easy stowaway (some can even be placed on the wall!) and lighter to carry than upright and cylinder vacs.

Sticks also have many useful accessories. Such as a crevice tool for awkward areas (car, stairs, etc), an upholstery tool for taking the crumbs off of your beloved furniture, and a motorized brush for collecting your fur baby’s pet hair.

Also read: Top 7 Industrial Robotics Companies in the world

Do I make more Dry messes or Wet Messes?

If you tend to have more dry dirt, dust, and a need to clear up allergens a bit too, dry vacuums are the way to go. Most homes have dry vacuums and they work okay. However, should a dry vac accidentally vacuum anything that’s wet, it must be stopped, cleaned, and bone dry before you use it again.

This brings me to the benefit of wet vacuums, which can clean moist and wet dirt as well as water or other liquids directly.

Also read: 7 Best Woocommerce Plugins to boost your Store you must know

Are cable-free vacs at the same performance level as cable vacs?

If you want the short and sweet answer, it’s yes. However, if they’ll work on your space, in particular, is another question.

If you have a big space to clean and would like to do all of your cleaning in one use, stick vacs smaller dust compartment and battery life with limits won’t work for you.

In truth, stick vacs are made for smaller spaces, like a studio or one bedroom apartment.

Also read: Top 10 Best Software Companies in India

Let’s talk about a term called Cleaning Reach

According to an official definition from the fabulous team at Dyson Australia, a vac’s cleaning reach or operating radius is the length between the power outlet and the farthest area that can be worked on with the vac.

An upright vacs cleaning reach is the length of its power cord, while the largest cleaning reach of an upright vac with a flexible cleaning hose attachment is the length of the power cord plus the length of the hose. Simple right?

Last Year In Tech: 2023 Edition

Magic Leap Goggles

We have seen some things. Oh my, have we seen some things.

Year-end wrap-ups are the best. We get to sit here in our new holiday pajamas and dish out harsh judgments on everything that happened during the past spin ‘round the sun. Interestingly, though, the end of 2023 doesn’t look all that different from the beginning. Smart home stuff is still popular, social media emotions still fluctuate wildly between “ooh, fun!” and “ooh, scary!” and nobody cares about fidget spinners.

So, before we roll into 2023, let’s take a look back at all the stuff that happened in the tech world since the last time they dropped the ball in Time Square.

Best of What’s New

If you want a look at the best new tech from this year, you should check out our 2023 Best of What’s New selections. It’s a collection of important and influential new products and technologies that came into the world in the last 12 months or so. It’s a great way to see promising new tech, free from all the negative stuff that also happened.

Fidget Spinners came and went

Google Trends: Fidget Spinners

Here, you can see the Google Trends graphs for “fidget spinner” (blue), as it compares to “Samsung Galaxy S8” (yellow), and “chicken fingers” (red), which apparently didn’t have a great year.

The Google Trends report—a graph showing how many people were searching for any given topic at any given time—for fidget spinners is fascinating. At the beginning of the year, these plastic toys registered a zero, but by the first week in April, the score was pinned to 100. It was a meteoric rise for a truly useless product. Now, the score sits around 3. The age of the fidget spinner ended as quickly as it began, leaving the toys relegated to their bargain bin coffins.

Net Neutrality died

The FCC voted to repeal 2023 regulations that classified the internet as a utility, meaning it should be equally accessible for all people. We won’t know for some time how this will actually affect the Web as we know it, but it opens up the door for internet service providers to start making crucial decisions about who gets access to what content and services. Get your wallets ready.

Augmented reality got more interesting (and less depressing than actual reality)

Ikea Place iPhone App

Digital chairs were all the rage in 2023.

We spent a lot of time this year fussing around with virtual furniture in our real-world spaces thanks to Apple’s augmented reality ARKit. Microsoft also bet big on AR by integrating its Mixed Reality tech into just about every device running Windows 10l. We even got to see the wonderfully ridiculous Magic Leap AR glasses for the first time after literally years of hype. Expect a lot of digital creatures—and probably also more couches—in your future.

WannaCry HQ trivia happened

The top app charts are still dominated by social media, smart assistants, and addicting games, but a live game show app made one of the biggest, loudest splashes. The app started earlier this year, but now gets hundreds of thousands of viewers during each one of its live shows, which happen twice each weekday and once a day on weekends. The show has had some hiccups, including its unnecessarily toxic live chat, but it’s carrying a lot of momentum into 2023. We’ll see if it fares better than QuizUp, another trivia app that raised tens of millions of dollars four years ago, only to lose most of its users and sell for a bargain-basement price.

AIM died

AOL Instant Messenger played a very important role in the formative years of many internet users, myself included. It was everywhere from college dorms to workplaces, and its away message function was the prototype for the eventual rise of social media—in which we have to type everything we think and feel into a text box that our friends can see and react to. Now, AIM is officially dead. I tried logging into my account before it was shut down, but I couldn’t remember the password. RIP, AIM. My 17-year-old self will truly miss you.

Bitcoin got expensive. Then it got cheaper. Now it’s kind of expensive again.

At the beginning of the year, a single Bitcoin was worth roughly $1,000. By the end of 2023, one Bitcoin is worth approximately $15,000. Of course, it might be zero tomorrow, or it could be $100,000 and all those who got in early will be driving around in yachts with the word “blockchain” written on the back. There’s no telling, really.

Tesla birthed a bunch of new vehicles

AMD came roaring back

With the release of its Ryzen processor products, AMD rose up to take on Intel’s position of CPU dominance in the PC world. Even if you’re not a total computer game geek, the competition is good if you plan on buying a new computer any time soon.


PUBG screenshot

This is a good place to pull your parachute if you want to float around for ten minutes and then die right when you land.

The biggest PC gaming hit of the year was Player Unknown’s Battleground, a multi-player free-for-all shooter that drops 40 players on an island where only one player can emerge victorious. The learning curve is relatively steep and the potential for mayhem is high, but the game crossed 30 million active players on PC alone before it got a port over to the Xbox One earlier this December. If you’re a player, you may have seen me crawling around in the fields, hoping to go unnoticed until I die anticlimactically.

Switch saved Nintendo

Both Sony and Xbox unleashed powerful new consoles this year, but it was Nintendo that dominated the living-room. With its portable playability and an arsenal of really excellent first-party games—including the best game of the year, The Legend of Zelda: Breath of the Wild—the Switch was the most fun gadget to happen this year.

HDR became really important Homes got smarter

Google Home Max speaker

The Google Home Max is the most powerful smart home assistant speaker around, at least for now.

We won’t know exactly how many smart home devices sold in 2023 until this year is in our rearview mirror, but Amazon says it sold “tens of millions” of Echos during the holiday season alone. Google doesn’t share its sales numbers, but with the Google Home Mini matching the Echo Dot’s $30 price point at most major retailers, it’s a fair assumption that they sold a bunch of them. The notable exception in the smart home boom is Apple, which missed its 2023 shipping window for the upcoming HomePod speaker, now slated for early 2023.

iPhone X

While Apple had trouble on the HomePod front, it also released the most-notable smartphone of the year. The iPhone X made waves with its FaceID unlocking tech as well as its $1,000 price tag. Real talk: Phones aren’t that much different at the end of 2023 than they were at its beginning.

Twitter grew up, literally Equifax leaked your info

Remember when one of the world’s biggest credit agencies gave up a bunch of crucial personal info on people who had never even actively engaged with the company as customers? That sure was fun.

Drones were kinda boring

DJI Spark

This tiny drone from DJI can understand hand gestures, which is cool, even if it’s not all that practical.

DJI unleashed its adorable Spark drone in 2023, but not a lot has changed in the space when it comes to hardware. We did get some confusing drone legislation though. In May, the government repealed the requirement for drone pilots to register their crafts when used recreationally. Then, in December the regulation came back. Not confusing at all.

The year in cameras

As a photographer and camera writer, this segment of the market remains close to my heart and, despite the continued dominance of smartphone shooting, cameras actually made a small sales comeback in 2023. Compact camera sales are still off the proverbial cliff, but both mirrorless cameras and DSL

OK, that’s it for 2023. Alexa, set an alarm for 2023.

How Adaptive Battery In Android Makes Your Phone Battery Last Longer

Adaptive Battery in Android Pie does something that Android users need: saves battery life. With a few adjustments, you’ll see your device’s battery last longer.

What Is Adaptive Battery?

Adaptive Battery is a battery-saving feature introduced in Android 9 that uses Alphabet’s DeepMind AI technology. Adaptive Battery is the result of Android and DeepMind teaming up.

The feature aims to predict the app you’re going to use and only allow those frequently-used apps to run in the background. The apps you rarely or never use will have a strict level of restrictions to help you save battery life.

The Adaptive Battery feature improves over time, as it learns how often you use your apps. When the feature has picked up how often you use your apps, it will place them in App Standby Buckets. These buckets are Active, Working Set, Frequent, Rare, and Never.

Adaptive Battery Buckets

When an app is in the Active Bucket, no restrictions apply. It can use the resources it needs to give you the best user experience. These are apps you open by tapping on a notification or open manually.

The Working_Set bucket is for apps you usually use but that you’re not using at that moment. The apps in this category only suffer mild restrictions. Apps you use indirectly can also fall into this category.

An app can be called Frequent if you (just like the name states) use it frequently but not daily. Apps in this category will have stronger restrictions when it comes to alarms and runs tasks.

The Rare Bucket speaks for itself. Here, you’ll find apps you only use every once in a while. Any app that is considered rare will have stern restrictions. For example, it will experience limitations when it comes to getting high-priority FCM messages, run tasks, and alarms.

If an app is in the Rare bucket, there is a good chance you forgot you even installed the app. These kinds of apps have rigorous restrictions.

Adaptive Battery could depend on an integrated app that also uses machine learning to decide how often you will use specific apps. If your device lacks this app, then it will monitor how often you use apps to determine what bucket they go into. But it will take some time for it to work at its best.

The bucket they are in will also determine how often the app can run tasks such as alarms and accept high-priority Firebase Cloud Messaging. When your device is charging, no restrictions are applied to the apps.

The apps that are placed in a bucket won’t be there forever. If how often you use an app changes, the bucket its placed in will also change.

How to Turn on Adaptive Battery in Android Pie

It’s also possible to see what apps have fallen into a specific bucket. To see this, you’ll need to unlock Developer Options in Android Pie.


Adaptive Battery is a step in the right direction. Thanks to this feature, you’ll be saving a good amount of battery life. What are your thoughts on the feature?

Fabio Buckell

Just a simple guy that can’t enough of Technology in general and is always surrounded by at least one Android and iOS device. I’m a Pizza addict as well.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Sign up for all newsletters.

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

Android Smartphones Drop In Price After Purchase Twice As Fast As Iphone

The service specializes in comparing prices within the framework of trade-in programs for exchanging old phones for new ones with a surcharge.

Android smartphones drop in price after purchase twice as fast as iPhone

As it turned out, in the first 12 months, Android smartphones lose twice as much of their value as the iPhone – 33.62% versus 16.70%. Two years after purchase, the price of Android is down 61.50% on average, while the price of the iPhone is down 35.70% on average. For four years, on average, the Android smartphone is cheaper by 81.11%, and the iPhone – by 66.43%.

As for individual brands, HTC, Motorola and Sony became the leaders in the rate of price reduction in the first year – by 53.08%, 42.57% and 39.51%. The slowest are iPhone and, oddly enough, LG and Nokia.

Samsung Galaxy S20 (-34.78% in 9 months), iPhone 11 (-12.84% for all 2023)

Samsung Galaxy S20 + (-30.59% in 9 months), iPhone 11 Pro (-21.31% for the entire 2023)

Samsung-Galaxy S20 Ultra (-36.30% in 9 months), iPhone 11 Pro Max (-15.96% for all of 2023)

Apple will reduce the notch of the iPhone 13 and improve the camera

Apple is slowly preparing a new generation of iPhone for release in the fall. Meanwhile, the network is beginning to accumulate details about the upcoming iPhone 13 models.

According to the source, the iPhone 13 will receive a redesigned Face ID system, which will reduce the so-called “notch” – a cutout in the screen for the front camera and the additional sensors.

It is also noted that the iPhone Pro models will receive larger camera sensors and improved resolution, while the base “non-Pro” versions will inherit the sensors used in the iPhone 12 Pro and iPhone 12 Pro Max.

iPhone 13 with sub-screen Touch ID this year, foldable iPhone also in the works

A new report from Bloomberg recently sheds more light on what to expect from the iPhone update this year. The report states that Apple “isn’t planning any major changes” for the 2023 iPhone 13.

Gizchina News of the week

Join GizChina on Telegram

The iPhone 13 or iPhone 12S models planned for this year are unlikely to feature any major design changes, as the 2023 ‌iPhone‌ models marked a major technological and design overhaul. Apple engineers would consider the 2023 iPhones to be an “S” version of the 2023 models.

The big change is that Apple is testing support for an in-display Touch ID reader for the iPhone 2023. Touch ID would be available in addition to Face ID and would be convenient for iPhone users who cannot unlock their iPhones when using masks.

Bloomberg writes that Apple has “discussed removing the charging port for certain iPhone models in favor of wireless charging”. It is not known if this change will be on the iPhone 13, or if Apple will keep it for a future model.

Speaking of the foldable iPhone, Bloomberg thinks you shouldn’t expect a foldable iPhone just yet. Apple’s main focus is on updates to its iPhone and iPad coming in 2023. But, the company is also working on the foldable model.

Finally, the report also mentions that AirTags are still on track for release this year. Apple was initially planning to launch them at the same time as the iPhone 12.

Apple To Name Next Handset iPhone 12S Instead Of iPhone 13

As a well-deserved giant in the technology industry, Apple’s products have always attracted attention. There were a lot of news about the next-generation products when the iPhone 12 series was just launched. Now, we learn that Apple may name the next-generation iPhone “iPhone 12S” instead of the iPhone 13.

The iPhone has launched a number of “S” series products in the past few years. Just like the iPhone 4S, iPhone 5S, and iPhone 6S, they were all outstanding. They are even called “a generation of magic machines” by users. The reason behind such a name is that they came with stronger functions than their rivals.

Moreover, the same sources claim the notch area of the upcoming iPhone 12S will be reduced as well.

Apple will use the latest D-ToF (Direct ToF) technology to replace the existing Face ID components. This will reduce the volume of the 3D structured light sensor module accordingly. Thereby, it will reduce the area of ​​the screen notch.

In addition, the new iPhone 12S will also use the LTPO screen provided by Samsung. This technology can support a higher refresh rate and greatly reduce the screen power consumption. The iPhone 12S will also support a high refresh rate of 120Hz. At the same time, it should also add frame rate synchronization technology. The latter brings intelligent adjustment of the screen refresh rate, which can automatically switch between 1-120Hz.

As for the performance, the iPhone 12S will also upgrade the Apple A15 processor, using TSMC’s second-generation 5nm process. The improved manufacturing process not only means more power, but also it will further reduce power consumption and improve the battery life of the 5G iPhone.

The iPhone 12S is expected to be officially unveiled in September this year.

Update the detailed information about Last Purchase Date In Power Bi: When Did Your Customers Make Their Last Purchase? on the website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!