Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
What is your source data? And how many birthdays you want to repeat for same person?
Can you share your expected result?
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |