3 easy steps to make a Current Week Sales KPI in Power BI

Power BI is a platform that allows you to connect to various data sources, transform and model your data, and create interactive dashboards and reports. Power BI can help you gain insights from your data and communicate them effectively.

What is a KPI?

A KPI, or a key performance indicator, is a measurable target that shows how well an individual or a business is performing in terms of meeting their goals. KPIs can be financial, such as net profit or revenue, or nonfinancial, such as customer satisfaction or retention. KPIs help organizations track their progress, identify their strengths and weaknesses, and make informed decisions to improve their outcomes.

Photo by Jazmin Quaynor on Unsplash

Building the KPI

We will be making this KPI:

So to calculate current week sales we require Week Number and Year from the dates column of our data which requires the need for a calendar table because there is a requirement of creating a calendar table whenever we are dealing with dates in Power BI.

1.DAX for calendar table creation:

Calendar = CALENDAR(MIN(car_data[Date]), MAX(car_data[Date]))

where the arguments are the start and end dates in the main table which here is…