Forum Discussion
Count IF / 'Set Analysis'
Hi All, Just started a new job where they use Power BI, having used Qlik in the past I am having trouble with getting the correct outputs. If I consider the table below ideally I...
Hi, Anonymous ;
If you could post sample data as text and expected output,It makes it easier to give you a solution.
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.
I will do my best.
so the raw data will come across like this
Vendor Name 1 Purchasing Document Material Material description Purchasing Group Month Material Doc. Year Corr. Qty. Reliab. Correction On-time del Sched. date GR date Schedule line number Post.qty. Quantity Received Scheduled Quantity Days to late WE Days to early WE Delivery Note Changed by Changed On Dat.reliab. and effectively for each Month and Vender I need to track the percentages of the 100.
as below
and then graphically represent it.
Thanks for all the support.