Dear Gurus,
I receive every day report in html format for 3 products store wise. I thought about using power query option of importing data from folder so i would put those files every day in the folder and refresh it in my query file. All is good but the problem is all files have the same format which i receive every day and it does not include any date in it so i cant identify date wise sales .
I need a solution in which all files i put in the folder in html format which doesnt have any dates in it,once ipmorted in to power query identify the dates itself so i can use slicers .
Regards
Zohaib
I receive every day report in html format for 3 products store wise. I thought about using power query option of importing data from folder so i would put those files every day in the folder and refresh it in my query file. All is good but the problem is all files have the same format which i receive every day and it does not include any date in it so i cant identify date wise sales .
I need a solution in which all files i put in the folder in html format which doesnt have any dates in it,once ipmorted in to power query identify the dates itself so i can use slicers .
Regards
Zohaib