Sum value based on date slicer

[Kanivan]

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

[Kanivan]

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

[YJ]

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:

PBIX 

Hope it helps, happy BI

[Kanivan]

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.

[v-chuncz-msft · Accepted solution]

@Kanivan 

You may simply use SUM to add the measure.

• https://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
• https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...

[YJ]

Hi,

Attached your pbix file and also give an example of what you try to archieve, it would be easier.

regards