Extract Date and Day of Month from Date column using Power Query

[BlueWhite3699]

Hi Expert

How would you extract from the date column the day and date intro a new column to show the following:

Column A

01/01/2025

02/01/2025

New Column

01-Wed

02-Thr

And so on - needs to be done on Power query as the FACT table has 11 million rows

[Ritaf1983]

Hi @BlueWhite3699 
From PQ you can use this formula
Text.From(Date.Day([Column A])) &"-"&Text.Start(Date.DayOfWeekName([Column A]),3)

But 
The best practise is to have this column in a calender table
+
Note that we have a format option directly from visualizations :

The pbix with the axample is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[vojtechsima · Accepted solution]

hey, @BlueWhite3699 

Click new column and write this:

Date.ToText([Column A],"dd-ddd", "en")

[BlueWhite3699]

Excellent - thank you

[vojtechsima]

@BlueWhite3699 
happy to help.