HOW?Calculated Column: if "this column" matches "this column" then display "this column" else "None"

[heathernicole]

I am trying to create a calculated column that looks at a couple of different columns - if they match, then display the number, if there's no match - display "No PO".

Here's an example: (there are actually thousands and thousands of rows for these two columns)

Type                          Number

Purchase Order          12345

Sales Order                 34567

Sales Order                12345

Sales Order                45769

Purchase Order          34567

Purchase Order          12567

What I need to get:

Type               Sales Order #     POs

Sales Order     34567                34567

Sales Order     12345                12345
Sales Order     45769                 "NO PO"

ANY assitance on this will be GREATLY appreciated!! 

The script I've created gets this error: DAX Comparison operations do not support comparing values of type Text.

Not very savvy with DAX yet...

Thanks in advance!!! 

[Sean · Accepted solution]

@ImkeF Thanks! This works great!

One thing I'll say if anyone is trying this don't rename a step "Filter Table" with a space

I don't know why it doesn't work with a space - use "FilteredTable" no space

Otherwise works great! Thanks again!

[Sean · Accepted solution]

You have to create a Relationship to the new Lookup Table you've just created...