I want to add custom column in my table for name of the day. It has column date already.
I know there is function FORMAT([date], "dddd"), but I don't know why it say "The name 'FORMAT' wasn't recognized" error ? Is it because of Diect Query method which is not suppoert that function ?
Go to Solution.
Most likely, it is not on the list of supported functions for DirectQuery:
Proud to be a Datanaut!
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.