Solved: Show upcoming Birthdays

PMUSUNURI · ‎06-20-2017

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

v-chuncz-msft · ‎06-21-2017

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] )
    )
)

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

View solution in original post

v-chuncz-msft · ‎06-21-2017

@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] )
    )
)

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