cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Disturbx
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 v-sihou-msft
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,

Disturbx
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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors