I am building a report in Power BI Desktop, created a slicer - YearMonthSort - which has data selection by Year-Month
Plz, see the screenshot below:
My goal is to limit data in this slicer as - 2015-07 to today's date (whichever it will be when users will look at the data, in the same format - "YYYY-MM")
In the "Filters" section I can select my starting year as 2015-07, but having problem setting today's date.
I tried to create the new Measure, but not sure where to place it, or, may be there is another way to perform this:
IsToday = FORMAT(TODAY(), "mm/yyyy")
I only just started to learn this, Thank you for help in advance!