Of Totals and Averages

[Mirithu]

Hi,

I am creating a report that shows the number of sales done by consultants since the beginning of the year. So far I have created a matrix visual which looks like this:

Now, I would like to add three columns: a totals column (as I do not wish to use the column subtotals option), and average sales per day, week and month. There is a date column in my table from where I can derive the months, weeks and days. Final matrix to look as below:

I have tried average calculations and functions to no avail. Please help?

[amitchandak · Accepted solution]

Hybrid columns are not supported. You May have to create a table of data and display.

Please vote for idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table

[Mirithu]

Thank you @amitchandak