Last three day

[jyaul786]

i have fact table with data by date, fact table is related with calendar table. and i need to get sum of last three day value based on date slicer(from calendar table).

Fact Table:

Date	value
10/12/2023	1
07/12/2023	2
06/12/2023	3
05/12/2023	4
04/12/2023	5
03/12/2023	6
30/11/2023	7
29/11/2023	8
28/11/2023	9
27/11/2023	10
26/11/2023	11

when i select date like range2:  then

result=1+2+3, 

when i select date like range2(8/12 or 9/12):

result=2+3+4.

how can i achieve , could you please help ?

[Ahmedx]

need to create an unrelated table

[jyaul786]

i cant create unrelated table, i have many table related with calendar table using as Dates slicer from calendar table. do you have any other way then please help me ? thanks

[Ahmedx]

pls try

[jyaul786]

Hello,

Thanks for your help, its working fine. Could you please do one more favour for another measure: when i select date range1 like:

the result_min = 6+7+8

and date range1 like:

result_min=3+4+5

How can i achieve this ? please help me.

Thanks

[Ahmedx · Accepted solution]

happened

pls try this

[Ahmedx]

Now it won’t work without an unrelated table since the date range does not fit into the slicer range