Sumifs with Custom Excel Data type from power Query and using dot notation

Question

I am just experimenting with Custom Excel Data Types and dot notation.&nbsp;I was trying to come up with a equivalent to sumifs without any luck.&nbsp; In my example I use fake data and I am trying to summairze charges by team color and departmentHere is a drop box link to my spreadsheetHere is&nbsp; the expected outcome&nbsp;YellowRedGreenPurpleOrangeRed&nbsp;Feet&nbsp;&nbsp; 1,384,281&nbsp;&nbsp; 1,067,303&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 884,288&nbsp;&nbsp; 1,112,979&nbsp;&nbsp; 1,005,634&nbsp;&nbsp; 1,167,165Hands&nbsp;&nbsp; 1,267,428&nbsp;&nbsp; 1,262,445&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 827,956&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 963,616&nbsp;&nbsp; 1,041,856&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 902,571Hip&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 946,395&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 948,135&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 955,020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 799,842&nbsp;&nbsp; 1,014,142&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 829,546Knee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 991,524&nbsp;&nbsp; 1,072,020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 953,689&nbsp;&nbsp; 1,139,318&nbsp;&nbsp; 1,218,487&nbsp;&nbsp; 1,001,327Spine&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 933,123&nbsp;&nbsp; 1,373,616&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 910,488&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 795,726&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 860,861&nbsp;&nbsp; 1,019,545&nbsp;

lorenzo · Answer

HiHere is a drop box link to my spreadsheet =&gt; Unfortunately there's no link in your initial post - Not necessarily your mistake as this site currently (&amp; randomly ???) drops ex. file attachments and hyperlinks are bugging as wellCould you try again please?

Forum Discussion

Sumifs with Custom Excel Data type from power Query and using dot notation

1 Reply

Resources

	Yellow	Red	Green	Purple	Orange	Red
Feet	1,384,281	1,067,303	884,288	1,112,979	1,005,634	1,167,165
Hands	1,267,428	1,262,445	827,956	963,616	1,041,856	902,571
Hip	946,395	948,135	955,020	799,842	1,014,142	829,546
Knee	991,524	1,072,020	953,689	1,139,318	1,218,487	1,001,327
Spine	933,123	1,373,616	910,488	795,726	860,861	1,019,545