Forum Discussion

Junaid11's avatar
Junaid11
Icon for Helper V rankHelper V
2 years ago

Show Previous Sales value based on slicer selection

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
 
Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    2 years ago

    Junaid11 add a measure with the following DAX expression:

     

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