Forum Discussion
Dax Help
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
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 👍
2 Replies
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 👍