How to filter a date based on Day/Month and not year for birthdays?

[DynamicsHS]

Hi, 

I am trying to create a table that shows peoples birthday based whether their birthday is today. I am pulling the information from dataverse and have a table with peoples birthdays that shows dd/mm/yyyy. When I go to filter it from accending to decending is bases that filter on the year. I changed the format of the column to dd/MM and tried to filter it again by accending to decending and it still filtered based on the year. 

How would I extract the day and month from the date (dd/mm/yyyy) so that I could have a table that filters based on the day and month of someones birthday and not show their year? 

and then be able to create the table so that peoples birthdays only show if their birthday is today.

e.g. example of the data 

Regards,

HS

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula

=format(Data[cdm_birthdate],"mmyy")

[mahoneypat]

In the query editor, make sure you convert your column to type Date (not DateTime), and then create a custom column with this expression to keep just the month and year. You could then convert that column to text or integer.

= Date.ToText([DateColumn], "MMdd")

Pat

[DynamicsHS]

Hi Pat, 

I change it to date. I then went to create a custom column and the "mmdd" comes up in red.

Ehen I press okay it comes up as an error? as says this: 

Any thoughts on how I could rectify this? 

Thanks,

HS