Rate

[Anonymous]

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.

[amitchandak]

Try like

YTD Avg = divide( CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"12/31")),
			CALCULATE(count(Date[Date]),DATESYTD(('Date'[Date]),"12/31")))

[Greg_Deckler]

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