Forum Discussion

PMUSUNURI's avatar
PMUSUNURI
Frequent Visitor
9 years ago
Solved

Show upcoming Birthdays

Hi Guys,   I have a column for 'Birthdays' - Dates, i am trying to show if there are any birthdays coming up in a week period. Any suggestions regarding this visual?   -Thank You
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    PMUSUNURI,

     

    You may refer to the following DAX that creates a new table.

    Table =
FILTER (
    Table1,
    CONTAINS (
        ADDCOLUMNS (
            CALENDAR ( TODAY () + 1, TODAY () + 7 ),
            "Month", MONTH ( [Date] ),
            "Day", DAY ( [Date] )
        ),
        [Month], MONTH ( Table1[Birthday] ),
        [Day], DAY ( Table1[Birthday] )
    )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

PMUSUNURI,

 

You may refer to the following DAX that creates a new table.

Table =
FILTER (
    Table1,
    CONTAINS (
        ADDCOLUMNS (
            CALENDAR ( TODAY () + 1, TODAY () + 7 ),
            "Month", MONTH ( [Date] ),
            "Day", DAY ( [Date] )
        ),
        [Month], MONTH ( Table1[Birthday] ),
        [Day], DAY ( Table1[Birthday] )
    )
)
PMUSUNURI's avatar
PMUSUNURI
Frequent Visitor
9 years ago

Thanks guys, i figured it out using your leads

  • AleksanderPunt's avatar
    AleksanderPunt
    Helper I
    8 years ago

    Can you please share your solution? :) I've been looking for a way to show upcoming birthdays (ranked to show the first upcoming at top) of employees.