Forum Discussion
Anonymous
7 years agoNot applicable
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
Anonymous seems like you are missing a quote
1 Reply
- parry2kSuper User
Anonymous seems like you are missing a quote