power bi whole column in dax function-CodePudding

Is power bi has a functional to input whole column in function instead of one cell from column?example with single cell and I got this result result of calculation. But is it possible to input whole column in that function?

CodePudding user response：

Yes, you can do this. You can pass in a list and return a table

Example:

let Source = (ColumnData as list) => let
    #"returnTable" = Table.FromList(ColumnData )
    in #"returnTable"
in Source

This you can make as your own customer function and call it from other scripts

Be careful to not create a circ. reference.

The way to solve the:

MyList = #"Your Table"[TYPE],
    
    #"Invoked Custom Function" = Table.AddColumn(#"Changed Type", "Convert", each Convert(MyList))