Date Format - Fri 9 Sept

[Power-User]

I am sure this is a simple question.

Can a date be converted to Fri 9 Sept  in PowerQuery or DAX ?

[ppm1 · Accepted solution]

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

[Power-User]

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 =

                        CALCULATE (SUM ('Attendance (Table)'[Present]) ,

                        Filter(ALL('Academic Year (Table)'),

                       'Academic Year (Table)'[This Week] <=MAX('Academic Year (This week) (Table)'[This Week])))

 

Present Total =

                        CALCULATE(SUM('Attendance (Table)'[Present]))