Add Calculated member row in my account dimension

[dz0001]

Hi There,

I am working Financial Statement in Power BI, basically reproduce the report from our OLAP cube, see below screen shot.

I need to add new member - Adjustment (highlight in yellow) in my account dimension which has the following formula:

Adjustment = Net Income - Pre-Tax Net Income - Tax.

Then Adjustment Net Income = Pre-Tax Net Income + Tax + Adjustment.

Is there way to accomplish this in Power BI?

[v-yuta-msft]

Hi dz0001,

Most of aggregations calculation in power bi are based on columns(like tabular model in SSAS). As a workaround, you can do some operations such as "Pivot" to change your original table like below and create two calculate columns using DAX formula:

Adjustment = [Net Income] - [Pre-Tax Net Income] - [Taxes]

Adjustment Net Income = [Pre-Tax Net Income] + [Taxes] + [Adjustment]

 

Regards,

Jimmy Tao