Forum Discussion

bahadbey's avatar
bahadbey
New Member
7 years ago

I'm having trouble converting an SQL query to DAX

Hello everyone,    I'm trying to calculate a turnover indicator for certain departements but I'm having trouble converting an SQL into DAX.   Here is my sql query which works using MSSQL Server. ...
Need Help
bahadbey's avatar
bahadbey
New Member
7 years ago

Actually my EmployeDept column type is Int and not String.

 

Here is my sample data.

 

 

This is the output of SQL Server

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

bahadbey did you try the measure I proposed, for integer, remove quotes around 1

  • bahadbey's avatar
    bahadbey
    New Member
    7 years ago

    Yes, of course. It shows (BLANK).