pk1593Helper I3 years agoTableau to DAX code Can anyone help in converting this code to DAX? S = ABS([x]-LOOKUP([x],-1))/ ( SQRT ( ABS(((([y] + LOOKUP([y],-1))/(SUM([z])+LOOKUP(SUM([z]), - 1)]))) * (1-(([y] + LOOKUP([y],-1))/(SUM([z])...Show More
pk1593Helper I3 years agoNo this is incorrect. I tried chatGPT but lookupvalue syntax is wrong and not a substitute for Lookup in Tableau.
ValtteriNCommunity Champion to pk15933 years agoI see, sorry about that. I just read the LOOKUP documentation in Tableau. The dax equivalent for LOOKUP would be OFFSET
Related contentDAX code issueDax code optimizationDAX codingConvert DAX to M CodeNeed Help - DAX Code
