Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
sum({<
Apportionment_Category={
'Fixed Assets',
'Inventory/CIP',
'Land'
},
Year_End_Flag = {'2'}
>}Amount)
+sum({<
Apportionment_Category={
'Depreciation',
'Gains/Losses',
'Other Income',
'Payroll',
'Rent/Leases',
'Sales'
},
Year_End_Flag = {'0'}
>}Amount)
SUMX(
FILTER(
'Table',
'Table'[Apportionment_Category] IN {
"Fixed Assets",
"Inventory/CIP",
"Land"
}
&& 'Table'[Year_End_Flag] = "2"
),
'Table'[Amount]
)
+ SUMX(
FILTER(
'Table',
'Table'[Apportionment_Category] IN {
"Depreciation",
"Gains/Losses",
"Other Income",
"Payroll",
"Rent/Leases",
"Sales"
}
&& 'Table'[Year_End_Flag] = "0"
),
'Table'[Amount]
)
Thanks
User | Count |
---|---|
54 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |