Is there a way to write a sub query in Power BI
Example: Select COL1 from Table 1
Where Table1.COL2 =
(Select COL3 from Table2)
Thanks in Advance
Go to Solution.
You could try this calculated table
New Calculated Table =
'Table 1'[COL2] = 'Table2'[COL3])
"COL1" , [COL1]
Proud to be a Datanaut!
Hi, I have Cosmos SQL that I want to apply. Cosmos doesn't support inner query.
I need to get first max of the record and then insert retireved value into another query. How can I do this in PowerBI ? I'm trying to execute SQL like below
select * from Employee where EmployeeId = ( select max(employeeid) from Employee)
Thanking you in advance.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!