Compose M Language Query

[Anonymous]

Hi,

I have a SQL Query but have no clue how to do this in M Language or Dax

see below the SQL Query

SELECT
  omission.*,
  CASE WHEN ISNULL(customer_department.id)
    THEN
      customer.name
  ELSE CONCAT(customer.name, ' (', customer_department.name, ')') END AS project_name
FROM omission
  LEFT JOIN project ON omission.project_id = project.id
  LEFT JOIN project_end_customer ON project.project_end_customer_id = project_end_customer.id
  LEFT JOIN customer ON project_end_customer.id = customer.id
  LEFT JOIN customer_department ON project_end_customer.customer_department_id = customer_department.id
WHERE omission.project_id IS NOT NULL;

kind regards

[Anonymous]

You can do this: The highlevel idea to get the result is :

In Power Query :

1. use the "merge " queries option in power Query to do left outer joins

2. Apply the filter for where clause.

3. Create a custom column using IF function for the project_Name column.

In DAX : You can create Table using NATURALLEFTOUTERJOIN for the joins and use FILTER() and IF() function.

Thanks

Raj