DESREF function

[Syndicate_Admin]

Good

how could I get a reference function in powerbi like DESREF, to construct the following formula:

A2	A3
20	1

=YES. ERROR(SI(DESREF(A2; A3;0;1;1)>0;(A2-DESREF(A2; A3;0;1,1))/(DESREF(A2; A3;0;1;1));"");"")

Greetings.

[v-jingzhang]

Hi @Syndicate_Admin 

There is no similar function in Power BI, but usually we can get the same outcome with some DAX calculation. Can you provide some sample data so that we can create a DAX expression that may work? It seems you are referring to a value in the same column to calculate a percentage value. Is 'A3' a fixed value? What is the relationship between 'A2' and the referred value? And do you calculate this formula for only a cell or for a column?

Best Regards,
Community Support Team _ Jing

[lbendlin · Accepted solution]

I assume you mean the OFFSET function?  

Please describe your business problem/logic. What are you expecting as an outcome based on your sample data?