Dates Day/Month only

Power BI
1

Annotation%202019-11-12%20120539
Annotation 2019-11-12 120539.jpg786×660 103 KB

Hi all,
I have a few tables that have data by year in each column. I want to show the information over a set time period for each of those years. I have a standard date table but don’t have a column that just shows the date and month only e.g. DD/MM. I have tried a column by example to split my DD/MM/YY column but it has this as text- and if i change to a date function it then adds back the year.

Is there a way to add a new column to my date table that just shows DD/MM and not year?

Thanks in advance.
Regards
Rob

2

@robH,

Here’s a very short video demonstrating how to set custom date formats. Should be able to set your day/month format easily using this approach.

https://youtu.be/DWjbd7NPUCM

  • Brian
3

Thanks Brian- Perfect!