Forum Discussion
Helper IWhat is wrong with this Rolling average (3months).
Super UserWe want to help you but your description is too vaugue. Please write it again clearly.
Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want to do. That would be crazy. 😀
Please just give a simple non technical functional decscription of what you want, then let us suggest the DAX. Thank you.
Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.
Remember not to share private data ... we don't want you to get into trouble. 😧
Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
You will get a quick response if you put time, care and effort into writing clear problem descriptions.
Vaugue descriptions can waste your time and ourtime.
Look foward to helping you when the above information is forthcoming
Helper IHey Speed,
I appreciate your response and I agree.
Therefore I am attaching the sample pbix file of what I want to accomplish.
1) I have data that I pull from a third-party source (API) and load into my Power BI report. In this case, I just used an Excel workbook with the same amount of data.
2) When I put the original prices in the matrix table (not the measure I currently have on there) it shows me gaps in between months because there is no price recorded in that month. Therefore I would take the previous month's price and duplicate it if the month's price is not available.
3) I want to be able to calculate the 3-month rolling average including the prices that I have copied from the previous month that had a value.
4) I believe I have managed to do all that but receive an error 'visual has exceeded the available resources' . I don't want it to do that because it is important to show that visual. Now one issue that I read about is that my measures are using up too much memory.
Would you be able to help me with this? Here is the link to the file:
https://go.wetransfer.com/t-kDe1NYkiDy
Thank you.
- sidvix917
Does anyone need clarification? Is there a way to solve this?