cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## Calculating upcoming birthdays

Hi,

I wanna try the possibility of showing upcoming birthdays, with birthdays today.

With following;

-Name

-Birthday

-New age

This data is saved in Excel.

Is this possible in powerbi or do I need another solution.

Thanks.

2 REPLIES 2
Moderator

## Re: Calculating upcoming birthdays

@Disturbx

What is your source data? And how many birthdays you want to repeat for same person?

Can you share your expected result?

Regards,

Highlighted
Frequent Visitor

## Re: Calculating upcoming birthdays

@v-sihou-msft

My data source is an Excel file. Which has the following fields; Name, Birthday and Age.

I want PowerBI to show the upcoming birthdays of the 7(or something) upcoming days.

So when its my birthday in the coming days i wanna show something like this

Upcoming birthdays

Tristan - 21 Oct. - Age 24

-

-

-

This far, I got some help;

```Verjaardagen = VAR next = MINX(
FILTER(
Leerlingen;
MONTH(Leerlingen[Verjaardag]) >= MONTH(TODAY()) &&
DAY(Leerlingen[Verjaardag]) >= DAY(TODAY())
);
CALCULATE(
DATE(
YEAR(TODAY());
MONTH(MIN(Leerlingen[Verjaardag]));
DAY(MIN(Leerlingen[Verjaardag]))
)
)
)
RETURN CONCATENATEX(
FILTER(
'Leerlingen';
MONTH(Leerlingen[Verjaardag]) = MONTH(next) &&
DAY(Leerlingen[Verjaardag]) = DAY(next)
);
FIRSTNONBLANK(Leerlingen[Naam]; 1);
" " & UNICHAR(10) & " "
) ```

Which hows all names for todays birthdays, but without age etc.

## Helpful resources

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

#### Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors