Forum Discussion
Is it possible to code this in DAX?
Hello World! Is it possible to code this in DAX - im having a hard time doing so and reltively new to DAX! =(X/Y)^(1/((P-Q)*100))-1 Where X and Y are related in the same column - P and Q are...
X & Y are given net conversion rates whist P & Q are Distrupts
For example
| -0.02 | 0.75% |
| 0 | 0.50% |
I think its worth noting that the table would look like this, so would need more than a 2x2 table and i would like it to update when the data refreshes (if possible)
| Disrupt | Header | Header | Header | Header | Header | Header | Header | Header |
| -0.02 | Cell | Cell | 0.75% | Cell | Cell | Cell | Cell | Cell |
| Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell |
| 0 | Cell | Cell | 0.50% | Cell | Cell | Cell | Cell | Cell |
I think I need somehting to refer to a specfic cell in a way