Dax Help

[Anonymous]

Hi all,

I have a query as below

I have po number and BaseNumber columns 
If po number is not blank then it's considered as "Po Yes"
If po number is blank and base number for that blank record Po number is having Po issued before then it's "Po No IK"
If it's only blank and base number for that po number is not issued as Po issued before then it's "PO NO"

Below I am pasting example

PO Number	BaseNum	PO Status
AAA	123	PO Yes
ABB	243	PO Yes
	123	PO No NIK
ACC	563	PO Yes
	789	PO NO
FCJ	898	PO Yes
	898	PO No IK
	789	PO NO

Po status should be my output

For row 3 PO num is blank but basenumber 123 is issued as Po issued before so it's considered PO NO IK

Please help 
thanks

[DOLEARY85 · Accepted solution]

Hi,

try this as a calculated column:

Column = if('Table'[PO Number]<>"", "PO Yes",if(CALCULATE(max('Table'[PO Number]),ALLEXCEPT('Table','Table'[BaseNum]))<>"", "PO No NIK","PO No"))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Anonymous]

Thanks a lot it helped !!