Creating own relative date slicer based on a selected value (SSAS Tabular model)
Hi, We have a report in which the customer wants to see 5 months before the selected yearmonth, the selected month and the 6 month after the selected yearmonth. In essence we want to build our own relative date slicer. There are many solutions in which rolling measures are calculated, but we want to limit the months shown in the report. I have seen solutions with a seperate date dable in which the fact is filtered based on the dates. We are workind with id's and not dates in the facts ánd we are working on SSAS Tabular model which limits options within PowerBI iteself. Any one have any suggestions how to solve this problem?