Total value measure on today + 15 days

[Anonymous]

I'm struggling to make this measure.

I need to get sum the values that I have to pay where the date is lesser than today + 15 days, and another one for today + 30 days

I've tryied dateadd, but it doesn't accept this with (today(), 15, day) neither with now()

How can I do that?

this is a example of my dataset

Data                    Título	       Tipo	Valor
2019-03-13 00:00:00	DDV-18071	DDV	R$ 16
2019-03-14 00:00:00	DDV-18076	DDV	R$ 360,9
2019-03-14 00:00:00	D-FOLHA 18077	DDV	R$ 39,1
2019-03-15 00:00:00	4919833	        1	R$ 188
2019-03-18 00:00:00	2023	        1	R$ 643,49
2019-03-18 00:00:00	5	        1	R$ 1004,28
2019-03-18 00:00:00	6	        1	R$ 7108,48
2019-03-18 00:00:00	8489	        1	R$ 4445
2019-03-18 00:00:00	DESP.CART-0219	1	R$ 1214,7

[Anonymous · Accepted solution]

You can try:

Today+15 = DATE( Year( TODAY()), Month( TODAY()), Day(TODAY())+15 )

then i think this measure would work for the total less than < today +15

 Less than 15 = 
 CALCULATE( 
     [Total Valor], 
     FILTER( 
         Table1,MAX( TodayPlus15[Date]) <= [Today+15])
)

[Anonymous]

Thank you Nick, that worked.

Now I have a new problem, how to make that values unchangeable by the date filters?

For example.

I am displaying that info in two cards, 15 days and 30 days, and I have a date filter. If I select a period out of the range (15 or 30 days) my values goes blank, I want it to be immutable.

Is there any way to do it?