Forum Discussion
Count IF / 'Set Analysis'
Hi，Anonymous ;
Why don't Vendor set Count of Column as Legend? If Vendor is set as Legend, logically it must be 100%, so you can try to set Count of Column as Legend.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the input, however I believe my issue is that the "Count of the column " is already a generated field it is not part of the intial load.
Whereas I see in your example it is loaded as a field.
My other issue that will come into it is that there will be multiple vendors within the data set, currently I am working with a smaller dataset in order to learn and practice.
script is below
= Table.TransformColumnTypes(#"Promoted Headers",{{"Vendor", type text}, {"Name 1", type text}, {"Purchasing Document", Int64.Type}, {"Material", type text}, {"Material description", type text}, {"Purchasing Group", type text}, {"Month", Int64.Type}, {"Material Doc. Year", Int64.Type}, {"Corr. Qty. Reliab.", Int64.Type}, {"Correction On-time del", Int64.Type}, {"Sched. date", type date}, {"GR date", type date}, {"Schedule line number", Int64.Type}, {"Post.qty.", Int64.Type}, {"Quantity Received", Int64.Type}, {"Scheduled Quantity", Int64.Type}, {"Days to late WE", Int64.Type}, {"Days to early WE", Int64.Type}, {"Delivery Note", Int64.Type}, {"Changed by", type text}, {"Changed On", type date}, {"Dat.reliab.", Int64.Type}})