Forum Discussion
Syndicate_Admin
Administrator
3 years agoGET AVERAGE GRAPH
Best regards
I come to your knowledge to obtain a solution to this requirement:
I have a graph that shows me the amount of income per day of the month
I get this from counting the number of cases per date, that is, the number of times a date is repeated.
Now I would like to calculate the average income for the month, which I have not achieved, to show it on a card.
I have tried several things but it does not work for me, I thank you for your support with a solution, thank you.
1 Reply
- amitchandak
Super User
Syndicate_Admin , Avg income as sum till date and avg post that
AverageX(Values(Date[Date]), calculate(Sum(Table[Income])) )
Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980