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 Approver, then it would be value "1st pass matching". 

 

And then I would like to create column, which tells me if there is "FI24" in Company Code column and "Technical Maintenance" in Purchase Category column and anything else but "Logistics" in Purchase Sub Category column and in Gift Cards column the values are starting with "BF", "L" and "P" then it would be value "PO". 

 

I would be very grateful, if you could help me out with creating these daxes. 

 

Best regards,

Kelly 

  • 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

15 Replies

  • 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

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Try to use this:

         

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