Forum Discussion
Summing up files extracted from SharePoint folder
Super UserAnonymous so file name tells which is for beginning of the month and which is the last date of the month or there is a date column that identifies start and end of the month
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
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.
Thanks parry2k
I have redacted my original file. Hopefully the enclosed file will help you, help me! 😁
https://drive.google.com/open?id=1rqoTuUJMz32yXOzUasZnFRSY9npNRFIN