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 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
