Forum Discussion
Any One Instance / At least One
Hi, I have three tables: "purchase orders" ; "jobs" and "quotations"
In "quotations" I have a Yes/No column which shows whether a Job requires materials from our Parent Company (lets call them ABC and the column [ABC HIRE YN].
I want to check that: If the Column 'ABC HIRE YN' = "Yes" for a particular job, then there is at least one purchase order to ABC in the purchase order table.
So far I did the following: I added a column Called ABC PO YN] to the Purchase Orders which picks out ABC as follows. If(Purchase orders [supplier]="ABC"; "Yes"; "No").
My visual includes 'Jobs',[Job Number], 'Purchase Orders'[PO Number], 'Purchase Orders'[ABC PO YN],'Quotations',[ABC HIRE YN]. 'ABC Hire YN' is filtered to "Yes" and I want to filter 'ABC PO YN' to "No"
The problem is that of course there are loads of Purchase orders for a project which are not to ABC. I just need to know if AT LEAST one is.
I do hope that the above is an adequate explanation of the problem!
Thank you
There's probably a smoother way of doing it, but I just COUNT'ed "YES" for each PO, and if that COUNT was > 0, then 'YES Present' else 'Yes Not Present'.
FOrrest
3 Replies
There's probably a smoother way of doing it, but I just COUNT'ed "YES" for each PO, and if that COUNT was > 0, then 'YES Present' else 'Yes Not Present'.
FOrrest
Brilliant! Thankyou. Worked a treat
HUlm1 - Hard to say exactly without sample data to test with. But, many times what you would do would maybe do a SUMMARIZE and see if there is a row for what you are looking for or a COUNTROWS(FILTER(...))
Beyond that, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
