Forum Discussion

KellyLen's avatar
KellyLen
Helper III
8 years ago
Solved

Problems with creating some custom columns

Hello,   I have a problem creating some columns.   Firstly, I would like to create column, which tells me that if there is "blank" in column Scanner ID and value "Basware Matching" in column Last...
  • MFelix's avatar
    MFelix
    8 years ago

    Try to use this:

     

    1st approver =
IF (
     'Table'[Scanned] = ""
        && 'Table'[Last Approver] = "Basware Matching",
    "1st pass mactching",
    BLANK ()
)
  • MFelix's avatar
    MFelix
    8 years ago

    Hi KellyLen,

     

    Try this formula:

    PO =
IF (
    'Table'[Company code] = "FI24"
        && 'Table'[Purchase Category (ext)] = "Technical Maintenance"
        && 'Table'[Purchase Sub Category] <> "Logistics"
        && (
            LEFT ( 'Table'[Gift Card/Traffic Type/Job No], 1 ) IN { "F", "P" }
                || LEFT ( 'Table'[Gift Card/Traffic Type/Job No], 2 ) IN { "BF" }
        ),
    "PO",
    BLANK ()
)

    Should give the result below:

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi  KellyLen,

 

You need to have this two calculated columns:

1st approver =
IF (
    ISBLANK ( 'Table'[Scanned] )
        && 'Table'[Last Approver] = "Basware Matching",
    "1st pass mactching",
    BLANK ()
)

Not really sure how you want to setup your second column you have 4 columsn to check values:

Company - = FI24

Purchase Category - = Technical Maintenance

Purchase Sub Category - <> Logistics

Gift Cards - Starts with BF L and P

 

value should be PO

 

Is this it?

 

Regards,

MFelix

 

KellyLen's avatar
KellyLen
Helper III
8 years ago

MFelix

I tried to use your given dax for 1st pass matching and unfortunately it did not work. Although it seems to be logical and it does not give me any error, there will not be any values in created column. 

 

And about the second thing, you got it right, I need to check values in 4 columns. 

 

Best regards,

Kelly