Forum Discussion
admin11
Memorable Member
Memorable MemberProblem 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
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
v-cazheng-msft
Community Support
Community SupportHi, 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
admin11