Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    2 years ago

    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 👍
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks a lot it helped !!