Forum Discussion

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

Problem Statement :- Create P&L Summary Table for GL ANALYSIS

Hi All https://www.dropbox.com/s/w3gim924bo13qql/PBT%20GL%20VER0025%20ONLY%20TI%20VIJAY%20V003.pbix?dl=0 Above link is the PBI file.   Paul
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, admin11 

    You can create a Measure to cope with it.

     

    SUM_YTD REV&COGS&EXP&OTH = SUMX('Table','Table'[Switch_YTD REV&COGS])

     

    The result looks like this:

     

     

     

    Best Regards,

    Caiyun Zheng

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi admin11 

change the formula If by Switch

 

Before that you need to add