Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create 2 date slicers with same Date column

Hi!!   I would like to create 2 date slicers that are using the same Date column. This is how i want it to work:    First slicer: is showing the last 7 days, always visible. Second slicer: is l...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You can create a separate table.

     

    Then create the measure.

    Filter results = 
SWITCH (
    SELECTEDVALUE ( 'Table (2)'[Slicer] ),
    "last 7 days",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', [Date] >= TODAY () - 6 && [Date] <= TODAY () )
        ),
    "last 30 days",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', [Date] >= TODAY () - 29 && [Date] <= TODAY () )
        )
)

     

    You can check more details from here.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi Anonymous - can you please share your data model if it does not have any sensitive data? Thanks!