Forecasting predictions for current year
Hello everyone, Trying to predict sales for current year. Already made measure: prediction (sales/number of days from the beggining of the year*365) - current sales. I want to add this measure to my visuals, but the problem is, that calculations are made for all the older years, and i cant filter out only current year value (maybe it is realationship problem - invoice date -> auto calendar). Idea what i want to do is this: Thank you for help!
Help required to replace blank value with a measure
Hi, I am trying to replace blank values in the column "value" with the max value if country = US. It is working fine if i enter replacement value as integer. Columns in Table A: Key, Country, Value Columns in Table B: Key, Country, Sales Thanks in advance!Using count of selected years to calculate average
Hi, I hope someone can help me out here 🙂 I have a graph which shows 2020 Revenue trend per month and another line which is 2017 - 2019 AVG, so you can see how much we differ from the trend and also what we can expect for the rest of the year based on history. Below that there is another one which shows the same but showing the yearly totals. I would like to 2017 - 2019 AVG line to dynamicly calculate based on the selection in the table below. So if you only click on 2019 then it basically compares 2019 to 2020, if you select 2018 + 2019 then it only devides thes SUM by 2 and not 3. For this I wrote a measure to count the selected years (and exclude 2020): Selected years count = IF(CONTAINS(FinancialData , FinancialData[Date].Year] , 2020)=TRUE, CALCULATE(DISTINCTCOUNT(FinancialData[Date].[Year]) , FinancialData[Date])-1, CALCULATE(DISTINCTCOUNT(FinancialData[Date].[Year]) , FinancialData[Date])) I checked and the calculation returns a number between 1 and 3, and it is a number. So I thought so far so good... Then I wanted to devide the sum of 2017 + 2018 + 2019 Revenue by the above. There is no syntax error but the calculation simply doesn't work 2017 - 2019 AVG Revenue = (FinancialData[2017 Revenue]+FinancialData[2018 Revenue]+FinancialData[2019 Revenue]) / [Selected years count] If I devide it simply by 3 it works perfectly but of course it is not dynamic and if you only select on or 2 years the calculation is off. Your support is much appreciated. Oliver
