Hello All, I am new to DAX and struggling with how to acheive a conversion for this SQL. I am unclear how to convert a calculation with multiple Case statements across multiple tables to one in DAX. Any help would be grately appreciated. SELECT DISTINCTsum((CASE WHEN (CASE WHEN a.BILLING_LINE_ITEM_CATEGORY_CD IN ('TANN','YBAN','YB1N','RENN','ZGNN','ZLNN') and d.MATERIAL_HIERARCHY_LEVEL3_CD NOT IN ('CH000CH090CH090025') and e.SO_DOCUMENT_REASON_CD NOT IN ('Z17','Z18','Z19','Z96','Z97','Z98') THEN 1 ELSE 0 END)=1 THEN (b.ADJ_ITEM_COST_LC_AMOUNT) ELSE 0.00 END ) * c.EXCHANGE_RATE) FROMSHARED_AREA.BILLING_DOCUMENT_LINE_TYPE_REF aINNER JOIN SALES_AREA.CUSTOMER_MATERIAL_DAILY_BILLING_FACT b ON (b.BILLING_DOCUMENT_LINE_TYPE_ID=a.BILLING_DOCUMENT_LINE_TYPE_KEYAND a.BILLING_LINE_ITEM_CATEGORY_CD NOT LIKE '%AE')INNER JOIN SHARED_AREA.CURRENCY_CONVERSION_REF c ON (c.CURRENCY_CONVERSION_KEY=b.CURRENCY_CONVERSION_ID)INNER JOIN SHARED_AREA.MATERIAL_DIM d ON (b.MATERIAL_ID=d.MATERIAL_KEY)INNER JOIN SHARED_AREA.SO_DOCUMENT_LINE_TYPE_REF e ON (b.SO_DOCUMENT_LINE_TYPE_ID=e.SO_DOCUMENT_LINE_TYPE_KEY)join SHARED_AREA.DATE_DIM dd on dd.date_key = b.BILLING_DATE_IDwhere dd.CALENDAR_DATE = '2019-11-15'

Great to have help in some ways. If I answer your question, please mark my post as a solution, this will also help others.Please give Kudos for support.Tomas Santandreu Polanco |Principal Business Intelligence Consultantwww.designmind.com

Calculation With Multiple Case Statements Over Multiple Tables - Convert SQL to DAX

Forum Discussion

Related content

Multiple IF statements in DAX

Multiple nested IF statements

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

DAX Calculate IF OR Statement

If Statement Calculated Column Returning Incorrectly