kamran_bsh Tracker

Re: Filter Columns

kamran_bsh — Tue, 21 Aug 2018 10:02:26 GMT

There is not enough information on what you are trying to do. If you want to take some of all product sales then try wrapping second part of calculate inside ALL function.

Please provide images of data

Re: Error in Stacked Column chart

kamran_bsh — Tue, 21 Aug 2018 09:53:55 GMT

Hello,

Could you please provide more information. Images of before & after will help. Plus some sample data

Re: convert columns into rows. Not Unpivot....I think....

kamran_bsh — Tue, 21 Aug 2018 08:42:44 GMT

If I understand correctly, please use below steps

First Group by Clash name and under operation use All rows

Then add a custom column using formula:

Text.Combine([Count][clashresults],", ")

This should give you the result you want.