How do I write a measure that averages column totals?
Beginner user here and have never asked a question in a forum before so I apologize in advance for the simplicity of the question or info I might miss adding for context. I have this table that I'm trying to replicate from Excel. I have included a screenshot of the Excel version and the Power Bi version. I want to display the average of the sums of each quarter. I am displaying this single value in a card (the one that is showing 131.85% right now) (I couldn't figure out how to do it in the table matrix). I know it can be done with DAX as a measure but can't seem to figure out what that would be. Is there an easy way to do this? I want the average to be off the quarters that have data, excluding the zeros for the future quarters). Excel version: Power BI version: Thank you in advance for the help.
Running Average Forecast
Hello all, i want to create a forecast based on past values in PowerBI using a measure. I have a big set of data with various information for the previous months (January to June) and need to use this data to create a forecast for the upcoming months with an average function. i.e. July vale = average of April may June white values are available, yellow data is not available and needs to be calculated. So it's kind of a Loop, I need to use the calculated average in October to calculate the average of November...
