cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Creating a date column with only day and month

Hi everyone,

I need to create a Data filter that shows me the values between, for example 1/09 to 20/11, of many years (i.e. 2017-2018-2019) all based on that period. How can I do it? Is it possible to create a date column that does not take into consideration the year and only report the day and month ?

Thanks for helping me,
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Creating a date column with only day and month

Hi @Anonymous it depends on user behaviour in your report.

but maybe the good solution will beto create date hierarchy which includes only Day and Month and try to work with it

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Creating a date column with only day and month

@Anonymous there are ways you can achieve this

Either you can use format function FORMAT('Table'[Date],"dd/MM")
or you can use CONCATENATE(DAY('Table'[Date]),CONCATENATE("/",MONTH('Table'[Date]))





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Anonymous
Not applicable

Re: Creating a date column with only day and month

Thanks, but this solution will give me a text format column, I need a date format because in this way the filter recognize the value as a date and let me filter between period. With a text format I have to select from the filter each day, and for a long period of month is a long process.
Highlighted
Super User II
Super User II

Re: Creating a date column with only day and month

Hi @Anonymous it depends on user behaviour in your report.

but maybe the good solution will beto create date hierarchy which includes only Day and Month and try to work with it

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors