Convert SAP BO measure with Foreach() operator to DAX formula
Hi I'm pretty new to SAP BO and I'm trying to convert a measure that I've found in a report to DAX language. The foruma uses the context operator FOREACH() on two columns ([Data].[KPI Group] and Data].[KPI Name] ) and I don't know how to write it in DAX. Could you please help me figuring out? Here's the code: SUM( IF( [Not Available] FOREACH( [Data].[KPI Group];[Data].[KPI Name] )="Y" ) THEN 1 ELSE 0 ) Thanks
DAX subtotals P&L reporting Direct Query
Hello everyone, I am making a P&L in Power BI with a direct query connection with SAP data and a hierarchy from SAP. The situation is that the SAP hierarchy could not be changed. I want to format the hierarchy with some small changes. How do i fix this at the best way? Is it possible with DAX? In the attachment i have provided a p&L file and some example data. Revenue is a positive number and costs are negative. This two minus each other is the subtotal of the EBITDA. What i want to create is the following: GL_account_level 3 Revenue Gl_account_level 4 Revenue Revenue cars GL_account_level 3 Costs Gl_Account_level 4 Cost Loan costs EBITDA (subtotal) GL_account_level 3 Depreciation Gl_account_level 4 Depreciation Depreciation cars EBIT (subtotal) GL_account_level 3 Interest (Regular exploitationresult subtotal) GL_account_level_3 Extraordinary income and charge Subtotal result before tax The current situation is the following: EBIT (level 1) EBITDA (level 2) Revenue (level 3) Revenue cars (level 4) Costs (level 3) Loan costs (level 4) Interest and depreciation (level 2) Extraordinary income and charge (level 1) Extraordinary income and charge (level 2) Extraordinary income and charge (level 3) Total Power BI result before tax I am searching very long for a good way how to fix this, so if anyone can help me i'm very happy:)