Forum Discussion

raymondvis's avatar
raymondvis
Frequent Visitor
5 years ago
Solved

Month filter

Hello,   I can't figure out how to arrange a filter that filters a table based on the current month. For the example table below I would like to use the following DAX measure: Filter = From monthn...
Need Help
  • raymondvis's avatar
    raymondvis
    5 years ago

    Thanks for the assist, but this still leaves the problem with article C for months 11 and 12 as they will result in "No" due to the last argument for MONTH (TODAY () ) <= [Until Month].

    I think I have found a solution by using the month numbers to create a date with new columns:


    From period =
    IF(
    [From month] > [Until month]
    && [From month] > MONTH( TODAY() ),
    DATE(
    YEAR( TODAY() ) -1,
    [From month],
    1
    ),
    DATE(
    YEAR( TODAY() ),
    [From month],
    1
    )
    )


    Until period =
    VAR MonthNr = [Until month]
    VAR Year =
    IF(
    [From month] > [Until month]
    && [From month] <= MONTH( TODAY() ),
    YEAR( TODAY() ) +1,
    YEAR( TODAY() )
    )
    VAR DayNr =
    CALCULATE(
    MAX( DateTable[Day of month] ),
    DateTable[Month Number] = MonthNr,
    DateTable[Year] = Year
    )

    RETURN
    IF(
    [From month] > [Until month]
    && [From month] <= MONTH( TODAY() ),
    DATE(
    YEAR( TODAY() ) +1,
    [Until month],
    DayNr
    ),
    DATE(
    YEAR( TODAY() ),
    [Until month],
    DayNr
    )
    )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

raymondvis 

You can just add another condition in case the from month is large than the until month.

 

Column = IF([From month]>[Until month] && MONTH(TODAY())<=[Until month],"Yes",
IF(MONTH(TODAY())>=[From month] && MONTH(TODAY())<=[Until month],"Yes", "No"))

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.