I have a measure (Account balance) which I want to calculate and show daily average for it for any date(sum of daily balance from the beginning of the year till that day/number of days tills that day) and user might not filter any date.
I am supposed to show a strait table which contains day (Dimension) and daily average for each day.
I read a solution in following article and it worked but with low efficiency, so if someone has another solution with set analysis ,I’d really appreciate.
If the above solution worked with low efficiency, any other alternative is going to give you worse performance compared to what you get with As Of Table.
