codeghi
04-17-2022, 06:07 AM
HI,
I've created a VBA function ("FzFind") that works well in Excel, it's declared as shown below:
Function FzFind(lookup_value As String, tbl_array As Range) As String
Dim i As Integer, str As String, Value As String
Dim a As Integer, b As Integer, cell As Variant
...
...
End Function
The problem is that when I'm into the Power Pivot tool and I try to recall that function by typing "=" in a cell of a new column, that function doesn't appear.
So, how could I recall my function in Power Pivot so that I'm able to use it in a DAX formula?
Regards
I've created a VBA function ("FzFind") that works well in Excel, it's declared as shown below:
Function FzFind(lookup_value As String, tbl_array As Range) As String
Dim i As Integer, str As String, Value As String
Dim a As Integer, b As Integer, cell As Variant
...
...
End Function
The problem is that when I'm into the Power Pivot tool and I try to recall that function by typing "=" in a cell of a new column, that function doesn't appear.
So, how could I recall my function in Power Pivot so that I'm able to use it in a DAX formula?
Regards