topic Re: DAX DirectQuery can't use FORMAT to know name of the day in DAX Commands and Tips

DAX DirectQuery can't use FORMAT to know name of the day

Anonymous — Mon, 07 Nov 2022 11:28:10 GMT

I need to make an dashborad where values get showen by name day. The problem is that i need to make an extra colum with name of the day but i can' use format cause i am using directQuery does somebody knows how i can get it?

thanks

Re: DAX DirectQuery can't use FORMAT to know name of the day

Samarth_18 — Mon, 07 Nov 2022 13:40:41 GMT

Hi Anonymous ,

You could refer to below thread:-

https://community.powerbi.com/t5/Desktop/Change-date-format-in-DIRECT-Query-Mode-not-on-list-of/m-p/781155

Re: DAX DirectQuery can't use FORMAT to know name of the day

Anonymous — Mon, 07 Nov 2022 14:15:07 GMT

that isn't where i am looking for

Re: DAX DirectQuery can't use FORMAT to know name of the day

AntrikshSharma — Mon, 07 Nov 2022 14:19:51 GMT

Anonymous That's a column that needs to be in the table by default, get your DBA to add it for you.