Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
ArashZ
Helper I
Helper I

measure to sum sales for specific months

‎08-04-2021 01:57 PM

Hi,

 

I want to create a measure to calculate the total sales for specific months. For example, in this example, from Feb to March.

DateSales
02-Feb3
02-Feb2
03-Mar6
03-Mar6
23-Apr8
24-Apr8
24-Apr9
01-May1

In fact, the measure should show this: (Excluding April and May)

Sale512
MonthFebMarch

 

Message 1 of 3
403 Views
0
2 REPLIES 2
amitchandak
Super User
Super User

‎08-04-2021 10:51 PM

@ArashZ , Use a date /month slicer.  Is that not working?

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 3
346 Views
0
ArashZ
Helper I
Helper I
In response to amitchandak

‎08-05-2021 06:24 AM

@amitchandakI don't want to use a slicer. I need to create a measure with DAX since I want to add that with another measure in the future.

Message 3 of 3
328 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

View All