Hi Guys,
I have been looking online for a while now and i cant find a way to create a dynamic way of naming a function inside the data model.
Let's say I have a Dataset called A and one Dataset called B (Txt files) which have the same layout that i am cleaning and appending through power query into one table.
I am trying for example to do a delta of col 1 in Dataset A and col 1 in Dataset B for specific attributes. (i need a function as I want to retrieve the function into the power pivot)
I am doing my delta calculation in the data model and the title of the function would be "Delta Col1 B vs A".
How can I create a dynamic function name that would become for example "Delta Col1 C vs A" if I added a new dataset C instead of B (I can retrieve the name of the dataset through the name of the text file)
Thanks in advance
I have been looking online for a while now and i cant find a way to create a dynamic way of naming a function inside the data model.
Let's say I have a Dataset called A and one Dataset called B (Txt files) which have the same layout that i am cleaning and appending through power query into one table.
I am trying for example to do a delta of col 1 in Dataset A and col 1 in Dataset B for specific attributes. (i need a function as I want to retrieve the function into the power pivot)
I am doing my delta calculation in the data model and the title of the function would be "Delta Col1 B vs A".
How can I create a dynamic function name that would become for example "Delta Col1 C vs A" if I added a new dataset C instead of B (I can retrieve the name of the dataset through the name of the text file)
Thanks in advance
