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.
I have a table with a date and a turnover column. I have made a date slicer. How can I get the sum of the turnover based on the range I have selected on the date slicer in DAX
Solved! Go to Solution.
You may simply use SUM to add the measure.
lets say i have the following table. if i select the slicer for example from 4 jan - 6 jan I want to get a measure of 2 + 4 + 3 = 9
date | turnover |
1-Jan | 5 |
2-Jan | 4 |
3-Jan | 4 |
4-Jan | 2 |
5-Jan | 4 |
6-Jan | 3 |
7-Jan | 5 |
8-Jan | 3 |
9-Jan | 2 |
10-Jan | 2 |
11-Jan | 4 |
12-Jan | 3 |
13-Jan | 2 |
14-Jan | 2 |
15-Jan | 1 |
HI,
Drop a slicer (slider on) and then drop a card or table depending on how you want to see the visuals:
See attached PBIX if needed:
Hope it helps, happy BI
thanks, but I want to know how to do this in DAX, its more for me to understand conceptually so I can use it for more complex structures.
You may simply use SUM to add the measure.
Hi,
Attached your pbix file and also give an example of what you try to archieve, it would be easier.
regards
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 |
---|---|
113 | |
97 | |
85 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |