Forum Discussion
Solved
Filter Page to Exclude Current Month
Hi everyone and thanks in advance. I have 3 years-worth of data that is continually being added to on a daily basis. At the end of each month I generate a report comparing that month and all mon...
One way would be to do something like this:
IsCurrentMonth = IF(MONTH([Date]) = MONTH(TODAY()),1,0)
Then just filter the page with IsCurrentMonth set to equal 0 only.
Do you need to setup a measure for Date first? How would you do it? Whenever I use [...] it only shows measures I have setup, it never shows the Date column in my Date table.