Forum Discussion
Dynamic Monthly Filtering with Exception Handling
I'm facing a challenge in Power BI and would greatly appreciate your insights and suggestions to overcome it. Here's my situation: I have a table with a date field and need to filter all the visu...
Anonymous - does your date table have a 'month offset' column? You could calculate the month offset, but alter this slightly to allow the buffer for today. You'd need to add an IF statement to check if the Day = 1, then MonthOffset-1.
https://community.fabric.microsoft.com/t5/Desktop/Month-Offset-rolling-12-months/td-p/3240050