Forum Discussion
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...
parry2k
Super User
Super UserAnonymous so if I understood correctly all the excel files are appended together with the file name as source column, correct? So what is not working? What you are trying to achieve?
parry2k Sorry, I don't think I answered your "what's not working" question.
As I mentioned, right now that formula only works if, after the = sign, the formula refernces a particular file (in source.name column).
I'm trying to get it to where I don't have to specifically mention a particular file, but can acheive getting to a particular result by using filters/slicers. So, to use the two tables in my original post. I would put two card visuals on the table, with the same measure, and just filter the measure differently for each visual.