Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |