Forum Discussion

BlueWhite3699's avatar
BlueWhite3699
Icon for Helper III rankHelper III
1 year ago
Solved

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

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

Need Help

4 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    1 year ago

    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