Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greetings PBI Team
I need to calculate the sales according to what is selected in the calendar, for example, if I have selected the year, the sales are calculated based on that selection, and the same for month and day. Here is an example of the measure I have to calculate the sales in the actual month
Can you please give me some help on this? thank you so much
Solved! Go to Solution.
Hi @FABIANSMITS ,
Please try to add a slicer like this:
You can achieve your goal by using sum of sales directly:
Or apply a measure like this:
Measure =
var _a = SELECTCOLUMNS('Calendar',"Date",[Date])
return CALCULATE(SUM('Table'[Total Sales]),FILTER(ALL('Calendar'),[Date] in _a))
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @FABIANSMITS ,
Please try to add a slicer like this:
You can achieve your goal by using sum of sales directly:
Or apply a measure like this:
Measure =
var _a = SELECTCOLUMNS('Calendar',"Date",[Date])
return CALCULATE(SUM('Table'[Total Sales]),FILTER(ALL('Calendar'),[Date] in _a))
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashley the measure is Current Month and is calculated this way:
and the measure for LAST_DATE_SALES is:
And what i want to do is to adjust my measure so that it can calculate the sales per year, month or day as selected
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |