Forum Discussion
Custom Date column won't connect to Date Table
I have 2 identical SQL queries that are respectively imported query and one direct query from an Azure SQL database. I need to make the imported query in direct query so I can make a scheduled re...
v-lid-msft
Community Support
Community SupportHi Rosenmeyer ,
Have you issue be resolved?Could you please provide more details about it If it still not be soleved? Please don't have any Confidential Information or Real data in your reply.
Best regards,
Hi v-lid-msft
I used this formula
Dato = CALENDAR(DATE(2018;7;1);Format(MAXX(VALUES(Sales[ClosedAt]);Sales[ClosedAt]); "dd-mmmm-yy"))
That I found in another thread. I also deleted the custom SQL query and selected the table through Power Query instead, somehow worked, don't know what the issue was.