Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
85 | |
52 | |
37 | |
23 |