Forum Discussion
Display the quarterly average on a Matrix
Hi brunohelder ,
If you need to show the quarterly average, you can change sum to average. if you need to add a column, you can check the following results:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for the reply.
I could not get it to work.
Your example has a table with date and the number amount for the date.
In my source table each entry is a line with a date and the quantity is 1 (one observation). The screenshot that I have sent is a count of the lines by date (Date Hierarchy). If I do an Average I get 1.
Hi brunohelder ,
Can you provide sample data, so that we can better solve the problem for you.
Best regards,
Community Support Team_ Scott ChangI am not able to attach files... Please find an example
Hi brunohelder ,
I made simple samples and you can check the results below:
AVG Count = var _t = ADDCOLUMNS('Table',"A",COUNTAX(FILTER(ALL('Table'),[Date].[Quarter]=EARLIER([Date].[Quarter])),[ID])) RETURN DIVIDE(AVERAGEX(_t,[A]),3)An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.