Forum Discussion
Clustered column average total
I created a sample pbix file but it won't let me drag and drop or copy-paste it here. how do I post it?
share via one drive ? google drive ?
this is the chart in the sample
It looks like this is totaling all the data in the table
are you saying, you would like to get these counts for a specific month's worth of data, and compare it with the total for the previous 3 months ?
Yeah the sample file I sent is only one day's worth of data so I couldn't show a time comparison but yes what I'm aiming for is to use the weighted tenure average measure you saw there as the value for each month (for three months in this case) and have an additional column that has the overall average for those three months. Ideally, I'd want it to be dynamic, so if I added a fourth month the overall average column would automatically update. If it helps, I can add a day of data to my test file from a different month to better show what I'm looking for.