Get Date and Day from date column

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

1 ACCEPTED SOLUTION

1 REPLY 1

Helpful resources

Announcements

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

Check out the March 2026 Power BI update to learn about new features.