I have a data set that i import in powerbi using power query and calling a function to transform my binary into a table.
My original data set consist in daily excel files that i transform slightly.
Recently i've stumbled accross a legacy database of the same data but arranged differently and i'l like to import it in the same table (there is a full year of data in a single file).
I was wondering what is the cleanest way to conditionnaly call my function:
- if daily excel, call function A to transform it and import in my table
- if yearly databse, call function B to transform it and import in my table.
I don't see the option to do that, i only see conditionnal columns but not conditional function calls in my powerbi desktop.
Thanks !
