Forum Discussion
Vba To power bi
Hello, please help me. I want convert this vba code for use on power bi with dax. Please help me. Many thanks Option Explicit Public Function Trocar(Cat As String, Produto As String, PVP As Doub...
Hi Daniff,
I don't think you can use DAX expressions to reproduce the 'do while loop' part. (search value, if statement, compare value parts and output the result are supports)
Power bi data model table does not include the row and column index. For the reference operation to the specific cells, you need to add filters to reduce the result ranges to point to the specific values.
For the DAX iterator functions, they are looping on the parameter table rows instead of looping in the range with particular exit conditions.
BTW, the recursive calculation also not supported in dax expressions.
Regards,
Xiaoxin Sheng