Is that what you're looking for?
Little change in KPI calculation
IF ZN([Ratio]) - LOOKUP(ZN([Ratio]), -1)< 0 THEN "DOWN"
ELSEIF ZN([Ratio]) - LOOKUP(ZN([Ratio]), -1) = 0 THEN "NO CHANGE"
ELSEIF ZN([Ratio]) - LOOKUP(ZN([Ratio]), -1) > 0 THEN "UP"
workbook v10.5 attached for your reference.
Sample v10.5.twbx 13.2 KB
Thanks for the reply. It wouldn't let me open the workbook since it's a newer version of Tableau. However, I changed the calculation per your recommendation but it is still returning null or in your case "".
To give an update in my question, it is still open. The formula described above MIGHT work. I put some of the dimensions into a text table and saw that the dimensions were being returned corresponding to a Null date and that it was using the wrong column for my calculations. However I cannot find any errors in my spreadsheet
See the attached
Your formula works just fine - you were getting a Null on the first value because the lookup( value, -1) didn-t have a value
just for demonstration I added a date with an equal ACQ value and a check for the first value
it returns this
to create the viz I just put you formula on the shape and on rows (calculated down) and included the measures
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
lookup problem.twbx 49.5 KB