How to make my Net Profit amount display at last row of P&L Table ?

[Paulyeo11]

Hi All

My P&L have 2 expression :-

(1) For Rev COSG and Exp

(2) For net Profit 

I need to combine the above 2 into 1 table.

My PBI file :-

https://www.dropbox.com/s/q1viboqgbkbow0w/GL_%20TDS%20v0008.pbix?dl=0

[amitchandak · Accepted solution]

@Paulyeo11 , You have to create a display table like this

summarize(
union(Table, Table[GL CODE], Table[cost center] , Table[Cost Name], "Amount", sum(Table[Amount])),
union(Table, "GL CODE", "564", "cost center" , 4 , "Cost Name" , [Net profit], "Amount", sum(Table[Amount]))
)

You can add other fields which you want to filter and join back with dimension tables.

Also refer: https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223

[Paulyeo11]

Hi Amit

thank you for share the link , it is very helpful