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.