I am working on a scenario wherein I need to display the values of same time last year(actually -11 month value) for the current month year selection. If nothing is selected in the slicer it should display the STLY values for past 6 months from the Max Sale date.
i.e. if I select 201912 then it should display sales of 201901 for 201912 and 201812 sale for 201911 so on.
I did achieve this using a disconnected table logic , but I require your help to see whether same can be achieved using without using disconnected table and a simpler logic.
Attached is the screen shot and the pbix of implementation done by me