Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to create a measure to calculate the total sales for specific months. For example, in this example, from Feb to March.
Date | Sales |
02-Feb | 3 |
02-Feb | 2 |
03-Mar | 6 |
03-Mar | 6 |
23-Apr | 8 |
24-Apr | 8 |
24-Apr | 9 |
01-May | 1 |
In fact, the measure should show this: (Excluding April and May)
Sale | 5 | 12 |
Month | Feb | March |
@ArashZ , Use a date /month slicer. Is that not working?
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
28 | |
21 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |