Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago
Solved

Calculated Column

Hello - I need help in creating a calculated column to return:-   If Purchase Order = “Email” or “TBA” or “TBC” and Reason is “Blank” Return “Pending PO” If Purchase Order has one digit value  and...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    4 years ago

    gauravnarchal add a new column using following DAX and it will do it, you can always tweak it as you see fit:

     

    Status = 
VAR __PO = PO[PurchaseOrder]
VAR __Reason = COALESCE ( PO[Reason], "" )
VAR __isNumber = NOT ( IFERROR ( VALUE ( SUBSTITUTE ( PO[PurchaseOrder], "/", "" ) ), BLANK() ) == BLANK() )
RETURN
SWITCH ( TRUE(),
    __PO IN { "Email", "TBA", "TBC" } && __Reason = "", "Pending PO",
    __isNumber && __Reason = "", "Uploaded in Progress",
    ( __isNumber && __Reason = "Uploaded") || ( LEFT ( __PO, 2 ) = "DW" ), "Uploaded",
    "Error"
)

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
4 years ago

gauravnarchal what you mean by this condition, can you clarify:

 

If Purchase Order has one digit value  

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago

Hi parry2k  - I mean all values in purchase order should be digits except "/" slash.

 

For eg:-  1063138/1064662 or 1063507/1063393/80064876 or 1063138