Forum Discussion
Solved
How to get day name on Direct Query
Hello! I'm trying to get the day name (monday, sunday, etc.) and I'm using DirectQuery, this limit the formulas I can use. I mean that I can't use WEEKDAY OR WEEKNUM directly. And I would like to c...
Hi adriancho_BI ,
bhanu_gautam Thanks for your concern about this case! I think your answer is pretty close.
After my testing, in fact you only need to use this DAX to create a measure, but it can't be achieved as a column:Measure = FORMAT(MAX('test'[Resolved Date]), "dddd")The final output is as below:
The test environment I use is Direct Query connecting to SQL.
And if you just want to know what day of the week the date is, you can directly select the Format here:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Use your date column and table name instead of that
You're right, that was the first thing I did after copy your suggestion /: then the error showed up.
Thanks anyways!