Forum Discussion
Memorable MemberProblem Statement 4 How to create a detail P&L Statement ?
Hi All
To below format :-
my PBI file :-
Below PBI file have solve the Sorting of P&L field and Provide Total Net Profit Amount :-
Paul
Hi admin11 ,
After checking your sample file and testing it, you can only display it through matrix visual. Cannot display in table visual by creating DAX.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
admin11 , Try if this old blog can help
https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223
admin11Hi All
v-chuncz-msft have manage provide solution for get the total amount , now hope some one can help to create break down sub total for REV , COGS , OTH , EXP.
V-lianl-msftCommunity Support
Hi admin11 ,
After checking your sample file and testing it, you can only display it through matrix visual. Cannot display in table visual by creating DAX.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
