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...
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.

    • mede's avatar
      mede
      Resolver I
      8 years ago

      This is also easy to achieve in query editor.

       

      Select your date column; go to "Add Column" tab; Date dropdown; you generate three new columns: Day Name, Day, Month Name

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Then, simply merge those three new columns using a delimiter such as "/" to get the format you need:

       

      Let me know if this works.

       

      If query editor is also not allowed, then you are supposed to do it in SQL directly in the data source.

      • joeydeacan's avatar
        joeydeacan
        Regular Visitor
        8 years ago

        **bleep** thanks man , it does work, but not in DirectQuery tho, wont let me add it in.

         

        Arrrgggghhhh so close, thanks for your help tho .