Forum Discussion
Rate
Hi everyone,
I need a measure calculating the current value of another one (which is accumulative along the year) divided by the number of days passed of the year, i.e: I have sold 1000 € since January 1st and today is January 20th => 1000/20 = 50€
I've got the measure for the sales and I've added a new column to the Calendar table that shows the day of the year, but I am not able to create the measure I need dividing both elements, the measure editor don't let me.
Many thanks in advance.
2 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Try like
YTD Avg = divide( CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"12/31")), CALCULATE(count(Date[Date]),DATESYTD(('Date'[Date]),"12/31")))
