Forum Discussion
jct999
Advocate II
Advocate IIIterator over a table.
Hi, I have a table with 4 columns and a few rows. I want to iterate over this table and pass each row to a personal function. This personal function simply creates a table using the parameters ...
MFelix
Super User
Super UserHi jct999 ,
You need to create a custom function and then when you expand the final result you get the table you need.
Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.
jct999Advocate II
Advocate IIThanks for your answer but it is not clear for me.
The table I want to iterate has 4 columns :
- FILE_NAME
- YEAR
- MONTH
- AUTHOR_ID
My personnal function just loads the file FILE_NAME in a table and add 3 columns to this table : YEAR, MONTH dans AUTHOD_ID.
Then, at the end, I want to combine all the table loaded in one table.
I can't send you my model nor PBix file... Could you show me an exemple.
Regards