- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Date Format - Fri 9 Sept
I am sure this is a simple question.
Can a date be converted to Fri 9 Sept in PowerQuery or DAX ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

In Power Query, you can use
Date.ToText([DateColumn], "ddd d MMM")
But I would just use ddd d MMM as the format string for your column or measure (so you can keep date sorting correct, use it with MIN/MAX in measures, etc.
Pat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

In Power Query, you can use
Date.ToText([DateColumn], "ddd d MMM")
But I would just use ddd d MMM as the format string for your column or measure (so you can keep date sorting correct, use it with MIN/MAX in measures, etc.
Pat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks Pat worked a treat.
I've brough it thought to PowerBi Desktop and called it 'This week'
When I need to use it in a cummulative measure is that what you are refereing to for MIN/MAX
Do I need to re-format it when I use it as a cummulative measure ?
Test Cummulatve =

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-16-2024 01:10 AM | |||
09-11-2024 05:50 AM | |||
06-27-2024 07:15 AM | |||
06-02-2024 04:30 AM | |||
04-13-2023 08:13 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |