topic How to join two DMV tables in DAX studio in DAX Commands and Tips

How to join two DMV tables in DAX studio

Anonymous — Thu, 01 Aug 2019 09:46:53 GMT

I am looking for a way to do a LEFT JOIN like in SQL but with DAX. I have two tables employee table and department table. I want to join two DMV tables(views) in DAX studio.

I have tried using the evaluate function EVALUATE NATURALINNERJOIN($SYSTEM.DBSCHEMA_COLUMN,$SYSTEM.TMSCHEMA_COLUMNS) but getting syntax error.

Re: How to join two DMV tables in DAX studio

Anonymous — Thu, 01 Aug 2019 11:04:07 GMT

Mate, you CANNOT query DMV's through DAX. DMV's do not belong to a model. They are queried via a limited version of SQL.

Best
Darek

Re: How to join two DMV tables in DAX studio

Anonymous — Wed, 10 Jun 2020 13:33:18 GMT

Can you possibly share what the operators, functions, etc. are in this "limited version of SQL?"

I am using DAX studio to query the DMVs and have learned that some operators just don't work like they do in 'real' SQL.