Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Two Date Filters(slicers)

I have a table I created and it has two dates in it:   Created and Modified.   I have a single page of visuals.    I Know I can create two slicers for the dates but I would like the user to only ha...
Need Help
Arentir's avatar
Arentir
Icon for Resolver III rankResolver III
8 years ago

Hi Anonymous,

 

I would suggest to have a separate date table. You create two relationships to created and modified date.

Only one can be active. But you can then create measures that use the relationship of choice.

For example:

CALCULATE(

             SUM(Amount),

             USERELATIONSHIP(MainTable[CreatedDate],Calendar[Date])

                  )

 

Hope this helps (and works ^^)