Forum Discussion
jyaul786
Helper II
Helper IILast three day
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 ?
happened
pls try this
