Forum Discussion
Vinothsusai
Helper III
6 years agoUnable to summarize the matrix table column same values in the cell (DAX)
Hi, I have a final matrix table combining two tables. Is it possible to summarize the matrix table column(Vendor Main Account Meas) same values in a cell. Customer Account Vendor Account Cu...
Vinothsusai
Helper III
6 years agoThank you for your reply.
Actually these multiple customer amounts are in a single cell. Like that we have multiple customer amounts, Customer Main accounts,vendor Mainaccounts and vendor amounts. How can we summarize this by Customer main accounts and vendor main accounts.
Please advise.
Thanks
Vinoth
v-gizhi-msft
Community Support
6 years agoHi,
Please refer to this:
https://www.excelguru.ca/blog/2015/10/16/split-by-line-breaks/
Hope this helps.
Best Regards,
Giotto Zhi
- Vinothsusai6 years ago
Helper III
Hi,
Thank you for your reply.
Could you please advise in the DAX. We have built this data from measures and we would like to fix this in dax. Is it possible to do that.
Thanks
Vinoth SUSAINATHAN