filmov
tv
Invoke Custom Function in Power Query | Power BI SS Skills || (Part-4)

Показать описание
In Query Editor, additional columns can be added according to your formatting or analysis needs.
We can use:
‘Column from Examples’ – when we know what kind of columns we want but not so sure about the exact transformation steps
‘Custom Column’ – where we can use M-code to write complex transformation formulas
‘Invoke Custom Function’ – which is useful when similar transformation steps need to be applied to many different columns
We have discussed these first three methods in this video.
We can use:
‘Column from Examples’ – when we know what kind of columns we want but not so sure about the exact transformation steps
‘Custom Column’ – where we can use M-code to write complex transformation formulas
‘Invoke Custom Function’ – which is useful when similar transformation steps need to be applied to many different columns
We have discussed these first three methods in this video.