We are working with a calculated column that is to return the Course Title value from Table 1 when the key values in a column matches to a value in Table 2. When the Course Title is a blank value, we want it to return “No Description”.
We have the following DAX expression, but it is not properly working. It’s giving the “No Description” value and providing “Blanks” where there should be the Course Title values. See below.
DB Equivalency Course Title = IF(‘Equivalencies’[DB Equivalency] = “Match”,(LOOKUPVALUE(‘DB Courses Summer 2020’[Course Title],‘DB Courses Summer 2020’[Subject-Catalog],‘Equivalencies’[Residential Subj-Cat Key])), “No Description”)