Forum Discussion

joeydeacan's avatar
joeydeacan
Regular Visitor
8 years ago

Display the date

Morning all,   I wonder if someone could help, I been experimenting with Power BI and Ive got to say I love, Im fairly new to both BI and SQL tho.   I am linking directly to a SQL direct Query, e...
mede's avatar
mede
Resolver I
8 years ago

Calculated Column:

Day = FORMAT(Dim_Date[Date], "dddd")

  • joeydeacan's avatar
    joeydeacan
    Regular Visitor
    8 years ago

    Thanks,

     

    Any chance you could walk me through a little, ideally i would like to format to be dddd/dd/mmm

     

    So day, then date then month ?

    • mede's avatar
      mede
      Resolver I
      8 years ago

      Hi joeydeacan

       

      I am not 100% sure if you are able to add calculated column in direct query mode.

      But normally, you can get that format by simply adding calculated column:

       = FORMAT(Dim_Date[Date], "dddd/dd/mmm")

      • joeydeacan's avatar
        joeydeacan
        Regular Visitor
        8 years ago

        Cheers mate , but I dont think I can do that on DirectQuery Mode.

         

        Maybe I can do something with the Query, but Im not that good either.