Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Calculations and Filtering

Good afternoon everyone,    I would like to be able to add "Current Date Range" slicer and a "Previous Date Range" slicer to the same report, yet I want one slicer to filter one column of data (i.e...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    There is no need to create a relationship between the calendar table and the fact table.

    Create a measure like this:

    Measure =
CALCULATE (
    SUM ( financials[ Sales] ),
    FILTER (
        financials,
        financials[Date] IN VALUES ( 'Table'[Date] )
            || financials[Date] IN VALUES ( 'Table 2'[Date] )
    )
)

    Sample .pbix

     

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