Forum Discussion

Power-User's avatar
Power-User
Frequent Visitor
2 years ago
Solved

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 ?

 

 

Need Help
  • ppm1's avatar
    ppm1
    2 years ago

    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

2 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    2 years ago

    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's avatar
      Power-User
      Frequent Visitor
      2 years ago


      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]))