Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hellow guys ,
this is my first question in the form and i wish i could find an ansuwer to it.
I have to note that iam begginer with M language .
My question is :
I am loading data from a folder which should contain more than 40 identical structured table, now these table arent in a good data set shapte. there is header in contacins comopany name and underneath it with few rows date of the report. the object is to retrive these tow field in put it in new columns right before i expand the tables so these record are attached to each row in each table when become in the same table.
Please refer to above picures for more details. and thanks alot in advance
Solved! Go to Solution.
Hi @AlaaRad
you can add a column with the following code:
[TransformFile][Column2]{1} to retrieve the Company name and
[TransformFile][Column2]{7} for the date.
See here for more information: http://excel-inside.pro/blog/2015/11/05/absolute-and-relative-references-in-power-query/
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @AlaaRad
you can add a column with the following code:
[TransformFile][Column2]{1} to retrieve the Company name and
[TransformFile][Column2]{7} for the date.
See here for more information: http://excel-inside.pro/blog/2015/11/05/absolute-and-relative-references-in-power-query/
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
thanks alot ,,its perfect
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.