How to join two DMV tables in DAX studio

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[Anonymous]

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.