Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

SQL query with outer applys

Hi

 

Is there a way to convert this query for the service? It works well on the Desktop version but not in the service

 

declare @From date
declare @to date
SELECT t1.*,t2.*,t3.*
FROM Fact f

Cross apply
(
select top 1
from dimension1 d1
where f.id=d1.id
and datefrom >=@From  and dateto <=@To
order by datefrom desc) t1

outer apply

(select top 1
from dimension2 d2
where f.id2=d2.id
and datefrom >=@From  and dateto <=@To
order by datefrom desc) t2

outer apply

(select top 1
from dimension2 d2
where f.id3=d2.id
and datefrom >=@From  and dateto <=@To
order by datefrom desc) t3

3 REPLIES 3
daxer-almighty
Solution Sage
Solution Sage

@Anonymous 

 

And you are posting such a question in a forum that is on "DAX Commands and Tips"?

Anonymous
Not applicable

@daxer-almighty to answer te obvious yes. This can't be done through the GUI, it's a DAX only, if possible in Power BI.

And it doesn't give you to think that nobody has even tried to answer your question for such a long time? I'd kindly suggest you read this before posting any kind of question on forums (not only this one).

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors