Direct Query today date function not working

[CraigBlackman]

I have a SQL table i am querying using direct query which dispays sales data for current month up to the current day and same peiod previous month.

However the table is displaying dates past today. The old import column used the following formula:

DATE = CALENDAR (MINX('order_header', [Order Date]), NOW())

This does not work in direct query.

How do i achive same result?

[v-yulgu-msft]

Hi @CraigBlackman,

Were you attempting to create a calendar table using the formula above when connecting to SQL server in Direct Query mode? However, this is not supported roght now, as the "New Table" feature is disabled.  To work around your issue, I think you should create that calendar table within SQL Server database, then load data to PowerBI as datasource.

Besides, someone has submitted this request, you can click here and vote it up.

Thanks,
Yuliana Gu