Forum Discussion
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...
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.
**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 .