Forum Discussion
Solved
Handling missing date column: Pulling date from one cell to create a date column in select files
Reposted (unable to continue with initial thread)). I'm importing data from hundreds of csv files into Power BI and I have a problem that I hope someone can help me resolve. Some of the files have a...
So as per my understanding, you wanted to get the sheet ( that has a date range and blank rows) to be transformed.
I have made the trasformations and the table now looks like thisPlease see the file for exact transformation steps ayan2_jpss_sol.pbix
If you find this helpful, Please Consider marking this as a solution.
There is no access to the file, please check it again, additionally you can also share your data or smaple of your data here also