IF, THEN, ELSEIF Statement in Tableau

Question

I have two Measures in Tableau, “Initial Loan Rating” and “Final Loan Rating”. Each of these two measures will use one of four ratings in them (Pass, Minor, Moderate, Severe). All of the “Initial Loan Rating” measures will have at least one of the four ratings. However, the “Final Loan Rating” measure not always will have this field populated.

I’m trying to create a calculated field that will look at the “Final Loan Rating” measure, IF field is empty THEN populate what is shown in the “Initial Loan Rating” measure. ELSEIF “Final Loan Rating” has something populated THEN show what is populated.

I know how to do this in Excel with the following formula =IF(b2<>””,B2,A2) I’m just having difficulty translating this to Tableau language.

Answer 1

Try the calculation field

IF [Final Loan Rating] = "" THEN [Initial Loan Rating] ELSE [Final Loan Rating] END

 Are you new to Tableau and want to learn more about it, then join the Tableau Training program provided by Intellipaat.