Show Previous Sales value based on slicer selection

[Junaid11]

Hello,

I have a date table connected to sales table date column now I want if I put date slicer and I choose date 23/2/2023 and 25/2/2023 which are 3 days selected in the date slicer then I want dax function to show sales value of previous 3 days like 20/2/2023 to 22/2/2023. So lets say if sales value from 20/2/2023 to 22/2/2023 is $3000 but when selection of slicer between date 23/2/2023 and 25/2/2023 it should show $3000 as same number of date of date so if I choose 4 days between date then previous 4 days date sales value should be shown

[parry2k]

@Junaid11 add a measure with the following DAX expression:

Previous Sales = 
VAR __Days = COUNTROWS ( ALLSELECTED ( 'Calendar' ) )
RETURN 
CALCULATE (
    [Sales],
    DATEADD ( 'Calendar'[Date], - ( __Days ), DAY )
)