I need help how to solve this in best practice .
I have Date dim , Users dim and Sales fact. I need to summarize sales by users and show only
active users . I got slicer by dates
But when I filter only active users that change’s also data from previous month ,so I need
show data for user that been active in slicer selected dates .
In user dim I have start day and end day ( active user have today date ; inactive the date of modification)