I want to filter a visual to always show the current month.
However, on the first day of the current month no data for this month has been loaded as yet. The data load takes place at the end of the Day 1 and is then refreshed overnight. In this instance I would like to keep showing the previous months data until Day 2 of the current month.
Is there anyway that I can achieve this using DAX? Any advice would be very helpful!