Relative Date Filtering

Hi bhmiller89 

Work this out with a workaround as below.

1. create a what-if parameter and get a new table named "Month" and a calcuated column and a measure.

2. create a new date table

Table 2 = CALENDARAUTO()

create relationship between "Table2" and your data table, don't create relationship between "Month" table and your data table.

3.create measures

this month = MONTH(TODAY())

start of this month =
CALCULATE (
    MIN ( 'Table 2'[Date] ),
    FILTER (
        ALL ( 'Table 2' ),
        MONTH ( 'Table 2'[Date] ) = [this month]
            && YEAR ( 'Table 2'[Date] ) = YEAR ( TODAY () )
    )
)


month diff = DATEDIFF(MAX(Sheet9[date]),[start of this month],MONTH)+1

flag =
IF (
    [month diff] > 0
        && [month diff] <= [month Value]
        && [month diff] <> 1,
    1,
    IF (
        [month diff] > 0
            && [month diff] = 1
            && MAX ( Sheet9[date] ) <= TODAY (),
        1,
        0
    )
)

If you have any problem, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.