Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Slicer weekly

Hello, everybody,   I created weekly coin sales and showing this week and previous week coin sales. Now to see both week, we need to click two weeks in a slicer part. But my customer wants to clic...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi Anonymous ,

 

Please use the below Dax formula to make new MEASURE to calculate last week sale.

 

lastWeek_Sales =
VAR WeekNum_LastWeek =
    WEEKNUM ( TODAY () ) - 1
RETURN
    CALCULATE (
        SUM ( 'table'[Sale] ),
        WEEKNUM ( 'Table'[Date] ) = WeekNum_LastWeek
    )

 

You can use this measure too show last week count when this week filter is selected.

 

 

do not hesitate to give a kudo to useful posts and mark solutions as solution.

 

Regards,

Gaurav Raj Singh 

LinkedIN : https://www.linkedin.com/in/gauravrajsingh/