1. A

    How to make a DAX measure NOT to re-calculate on aggregated levels?

    I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. instead of looking at July or August, look at Year Total)? The problem is the aggregated number...
  2. G

    Pivot Table for Student Data?

    Hi there. I'm trying to find a way to do something for teachers in my school district. They would like to see testing data from several different platforms aggregated by student. The issue I'm facing is getting the Pivot Table to aggregate the scores by Student ID but show only one instance...
  3. A

    Disaggregating data

    Hello Does anyone know VBA code to transform X into Y? <colgroup><col width="64" span="3" style="width: 48pt; text-align: right;"> </colgroup><tbody> X F Y 1 1 1 2 2 2 3 1 2 3 </tbody> Regards António Teixeira
  4. A

    Sync query results back to initial file after updates

    Hello all, I have a directory that contains monthly lead reports - one Excel spreadsheet per month. I have an aggregated spreadsheet that takes all the data from each of the monthly spreadsheets to show all the data for all months. I do this by using the "get data" -> from file -> from folder...

Some videos you may like

This Week's Hot Topics