Forum Discussion
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...
Try to use this:
1st approver = IF ( 'Table'[Scanned] = "" && 'Table'[Last Approver] = "Basware Matching", "1st pass mactching", BLANK () )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
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
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