Help with displaying value if there is no ones birtday today

[Anonymous]

Hi, im making a birtday dashboard for my company.

I think ive gotten it to work. My only issue is that if there is no birthday today the displayed information is just "has birthday today!".

I'd love to make it so the text displays "No one has birthday today" when there is no birthday at todays date.

This is how the text looks when there is no birthday that day:

Here is the DAX, some of the text is in Norwegian:

Hvem har bursdag i dag? = VAR next = MINX(

    FILTER(

        Ark1,

        MONTH(Ark1[NesteBursdag]) = MONTH(TODAY()) &&

        DAY(Ark1[NesteBursdag]) = DAY(TODAY())

    ),

    CALCULATE(

        DATE(

            YEAR(TODAY()),

            MONTH(MIN(Ark1[NesteBursdag])),

            DAY(MIN(Ark1[NesteBursdag]))

        )

    )

)

RETURN CONCATENATEX(

    FILTER(

        Ark1,

        MONTH(Ark1[NesteBursdag]) = MONTH(next) &&

        DAY(Ark1[NesteBursdag]) = DAY(next)

    ),

    FIRSTNONBLANK(Ark1[Navn], 1),

    " & "

) & " har bursdag!"

Thanks 🙂

[Anonymous]

Hi @Anonymous ,
I ithink they meant like this. Try it :

Hvem har bursdag i dag? = VAR next = MINX(
    FILTER(
        Ark1,
        MONTH(Ark1[NesteBursdag]) = MONTH(TODAY()) &&
        DAY(Ark1[NesteBursdag]) = DAY(TODAY())
    ),
    CALCULATE(
        DATE(
            YEAR(TODAY()),
            MONTH(MIN(Ark1[NesteBursdag])),
            DAY(MIN(Ark1[NesteBursdag]))
        )
    )
)
var _result = CONCATENATEX(
    FILTER(
        Ark1,
        MONTH(Ark1[NesteBursdag]) = MONTH(next) &&
        DAY(Ark1[NesteBursdag]) = DAY(next)
    ),
    FIRSTNONBLANK(Ark1[Navn], 1),
    " & "
)
RETURN
IF(ISBLANK(_result),"No one has birthday today.",_result & " har bursdag!")

Regards

[SpartaBI]

@Anonymous 
Hey, hard with the language 🙂 but hopefully you can adjust this logic to your VAR/Measure names needed:
change the last RETURN to VAR named "result" and then:
RETURN
IF( NOT ISBLANK(Birthday), _result, "No one has birthday today")

[Anonymous]

Hi and thank you for the reply. Im pretty new to powerBI and DAX in general, so im not sure how i apply your answer into my code. Do you think you can elaborate or link me to a resource where i can understand it better?

Ive translated the code to english 🙂

Whos birthday is it today? = VAR next = MINX(

    FILTER(

        Table1,

        MONTH(Table1[Nextbirthday]) = MONTH(TODAY()) &&

        DAY(Table1[Nextbirthday]) = DAY(TODAY())

    ),

    CALCULATE(

        DATE(

            YEAR(TODAY()),

            MONTH(MIN(Ark1[Nextbirthday])),

            DAY(MIN(Ark1[Nextbirthday]))

        )

    )

)

RETURN CONCATENATEX(

    FILTER(

        Table1,

        MONTH(Table1[Nextbirthday]) = MONTH(next) &&

        DAY(Ark1[Nextbirthday]) = DAY(next)

    ),

    FIRSTNONBLANK(Table1[Name], 1),

    " & "

) & " has their birthday today!"

[SpartaBI · Accepted solution]

Hey @Anonymous try this:
Not sure if _result return blank when there are no birthdays, so if not I'll change the code a little bit

Whos birthday is it today? =
VAR next =
    MINX (
        FILTER (
            Table1,
            MONTH ( Table1[Nextbirthday] ) = MONTH ( TODAY () )
                && DAY ( Table1[Nextbirthday] ) = DAY ( TODAY () )
        ),
        CALCULATE (
            DATE ( YEAR ( TODAY () ), MONTH ( MIN ( Ark1[Nextbirthday] ) ), DAY ( MIN ( Ark1[Nextbirthday] ) ) )
        )
    )
VAR _result =
    CONCATENATEX (
        FILTER (
            Table1,
            MONTH ( Table1[Nextbirthday] ) = MONTH ( next )
                && DAY ( Ark1[Nextbirthday] ) = DAY ( next )
        ),
        FIRSTNONBLANK ( Table1[Name], 1 ),
        " & "
    )
RETURN
    IF (
        NOT ISBLANK ( _result ),
        _result & " has their birthday today!",
        "No one has birthday today"
    )

[Anonymous]

Thanks! It worked like a charm!