How to display sales data in the past 30-60-90 days

  • Published
  • Posted in Power BI
  • Updated
  • 2 mins read
  • Tagged as

In this blog, I’ll explain how to calculate sales for the past 30-60-90 days and display sales data with the help of the Slicers.

The steps we take to display sales data in the past 30-60-90 days
Step1. Create a table with the help of Enter Data option.

Step2. The table we have created in the above steps will be used in the slicer to filter the data for the 30/60/90/days range.

Step3. Create a new measure for calculating the past 30/60/90 Days’ sales.

Logic:-
Last 30/60/90 Days sale =

var days_30=CALCULATE(sum(‘Orders'[Sales]),FILTER(‘Date Table’,’Date Table'[Date]>=TODAY()-29&& ‘Date Table'[Date]<=TODAY()))

var days_60=CALCULATE(sum(‘Orders'[Sales]),FILTER(‘Date Table’,’Date Table'[Date]>=TODAY()-59&& ‘Date Table'[Date]<=TODAY()))

var days_90=CALCULATE(sum(‘Orders'[Sales]),FILTER(‘Date Table’,’Date Table'[Date]>=TODAY()-89&& ‘Date Table'[Date]<=TODAY()))

return

IF(MAX(‘Table'[Last 30/60/90 Days Sale])=”30 Days”,days_30,

IF(MAX(‘Table'[Last 30/60/90 Days Sale])=”60 Days”,days_60,

IF(MAX(‘Table'[Last 30/60/90 Days Sale])=”90 Days”,days_90)))

Step4. Drag the measure in the card and select the value in the slicers.

You can see in the screenshot above that shows the sales value for the 30 days. We’ll choose the slicers if you want to show 60 or 90 days.

Rahul Prajapati
Data  Analyst

Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.

Email Us Or Contact Us