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 click just once on a filter choosing just one week, previous week appear automatically.

 

Is there any method to click just one and see with previous week cooin sales as well?

 

Thank you always.

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Make a disconnected date table and use it in slicer.
    Create weeknum column in your main table and date table.
    And then create two seperate measures of this week and previous week and use it in your table visual.

    This week sales count=Calculate(count([table,[col]),filter(table,table[weeknum]= min(date[weeknum])))
    Similarly create for previous week by simply adding -1 at the end.



    Thanks
    Pravin
  • 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/