How to Calculate The Number of Transactions Made in the Last N Days – Power BI Using DAX

No comments

Sometimes with your analysis in Power BI you may want to know how many transactions have occurred over a particular period of time.

In this particular tutorial, I’ll show you exactly how you can calculate transactions within a given period of days. 

Analyzing the transactional frequency could be crucial for a business.  Especially if you are a high-frequency retailer or running an online company. Insights such as this can really drive many actions and decisions around many aspects of a business including marketing, inventory or financial initiatives.

In this example,  we will run through calculating transactions done in the last 60 days. Remember while reviewing this..it doesn’t always have to be transactions, it could be sales, costs or profits that could be reviewed using the same exact technique I showcase.

This tutorial covers a highly-quality piece of analytical work that can be efficiently executed inside of Power BI and explains how you can use the technique in your promotional or marketing activities.

The technique can be used in so many different ways in the right environment. If you can expand your mind around how you can incorporate this in your reports then, you’ll be developing high-quality work that your consumers and organization are going to value.

To learn even more advanced analytical techniques for Power BI, check out the module link below from Enterprise DNA Online.

Advanced Analytics in Power BI 

Good luck!

Sam.

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s