Forum Discussion
How to join two DMV tables in DAX studio
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 ...
- 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
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
Best
Darek
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.