Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Summing up files extracted from SharePoint folder

I have imported the contents of a SharePoint folder that contains several Excel files.  After import, the contents are extracted and each of these files (and their respective rows of data) show up un...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry, one more thing! There is a date column (tied to the date table) that is called Est.Close Estimated Close represents the date the salesperson thinks the deal will ship.    (no idea why we called it that...but that is what it means).   

 

So, we are comparing all of the opportunities at the beginning of the month, with the opportunities on the report at the end of the month, based on estimated close dates relative to that month.  

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous This is what I would recommend, slap sample data of few months in excel sheet (few rows) and also expected result and share it through one drive/google drive. Remove any sensitive information before sharing it.

 

You solved one part to append all files together, after that it is a matter of putting DAX measures together and for that need to see the data.