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,

 

The formula should be something like this:

 

SEARCH( "IKL", 'Table'[Document header], 1 , 0 ) > 0

This should be added to your calculation.

 

Regards,

MFelix

KellyLen's avatar
KellyLen
Helper III
8 years ago

Thank you very much, MFelix!! :) 

  • KellyLen's avatar
    KellyLen
    Helper III
    8 years ago

    Hi MFelix,

     

    Could you please help me again? 

     I have created a column, where I use LOOKUPVALUE to get the needed values. Right now the DAX is following:

    Contract status = 
LOOKUPVALUE('Processed CLM data'[Status]; 'Processed CLM data'[Vendor number]; 'Contract coverage'[Vendor number])

    I would like to add here a condition that if in column "Category" there is value "Tour" and in column "Profit" value "12201" and in column "Account" values "123" and "345" then it would mark the status as "First". Otherwise it would use the lookupvalue condition. 

     

    Are you able to help?

     

    Best regards,

    Kelly 

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi KellyLen,

     

    Assuming that you columns are on the same you need to add something like this:

     

    Status =
IF (
    Table[Category] = "Tour"
        && Table[Profit] = 12201
        && Account IN { 123, 345 },
    "First",
    LOOKUPVALUE (
        'Processed CLM data'[Status],
        'Processed CLM data'[Vendor number], 'Contract coverage'[Vendor number]
    )
)

     

    Made this without having any knowledge of the columns and tables where they are.

     

    Regards,

    MFelix

  • KellyLen's avatar
    KellyLen
    Helper III
    8 years ago

    MFelix Super! It worked! Thanks a lot again! :) 

     

    Best regards,

    Kelly