Forum Discussion
DECLARE statement in PBI using DirectQuery
Hi, I'm using a direct query SQL in PBI. While using a DECLARE statement, it throws an error Incorrect syntax near the keyqord 'DECLARE'. Incorrect syntax near ')' My SQL statement is as fol...
amitchandak
Super User
Super UserAnonymous , This you can use as sub query, Try that way
select * from abc
join ....
where date in (select distinct effective_date from in.input_table)
group by....