cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kfchaef7 Frequent Visitor
Frequent Visitor

Dax/Mquery syntax to include a query within the load statement.

Need another pair of eyes to see where I am missing something to allow for this data source with a query>

 

= let
Source = Sql.Database("Test", "Reporting", [Query="SELECT * FROM [dbo].[Invoice] WHERE [InvoiceDate] >= DATEADD(DAY, -90, GETDATE()) ORDER BY [InvoiceDate] DESC)
in
Reporting

 

Please help.

 

Thanks,

 

karen

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dax/Mquery syntax to include a query within the load statement.

@kfchaef7 seems like you are missing a quote 





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




1 REPLY 1
Super User
Super User

Re: Dax/Mquery syntax to include a query within the load statement.

@kfchaef7 seems like you are missing a quote 





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.