Thank you so much - I was looking to filter column B, and not looking for the value filter in that column. I appreciate your courses, they have been ...
I struggle with this as well. My dashboard layout is fluctuating a lot based on the items I choose to filter by, or upon refresh. I find it puzzling...
My list of duplicated student ids returns the number of distinct students with this funciton. I would like to report in my pivot table values where ...
Okay - I am attaching a sample file that hopefully will help. I have loaded my queries to tables and the data models, but they are sourced from files...
Here is my base query - I have lots of other queries that either reference, or merge with this query in my file. let Source = Csv.Document(File.Con...
Got it - that is what I did - just wondered if there was another way. Thank you!
If my Power Query exists in a separate workbook can I use it in Power Pivot without first adding that query to the current workbook? I am having trou...
Exactly what I came here looking for. Thank you! I am attempting to identify the the rows that have the highest FTE for students that are duplicate...
Okay - trying again. See attached desired result.
Thank you - Sorry for not being more clear. Unfortunately, the data I am trying to merge comes initially from so many confidential files containing p...
The result I would like should list the student, and each course in the a column that indicates the term that the student took the course. (school ye...