Forum Discussion
Handling missing date column: Pulling date from one cell to create a date column in select files
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.
Thank you Jpss and Omid_Motamedise
Here are the links. I'm importing from a folder in C drive to Power BI.
Report 1: https://docs.google.com/spreadsheets/d/1I6MmH2gBzibr6_uuwxQBOTfAMzdgWUGxGzKhxhgwGG0/edit?usp=sharing
Report 2: https://docs.google.com/spreadsheets/d/1xMyDm_5dS9MUxox_UYx1uNNzO3V7GsxcMCVQY7KtLhE/edit?usp=sharing
Expected: https://docs.google.com/spreadsheets/d/1QI-dzcWZCiz115aSBFiAho9gyLxeuzghmDfhiA2L5UI/edit?usp=sharing
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 this
Please see the file for exact transformation steps ayan2_jpss_sol.pbix
If you find this helpful, Please Consider marking this as a solution.
Thank you very much!