Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |