Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

Problem 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 :-   https://www.dropbox.com/s/ekex9q6ph1lz6ws/PBT%20G...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

Hi 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-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.