Prior Month Daily Average

[ExcelWizard18]

Hello - I have the following table, and I'm trying to add two new columns: "Prior Month Avg" and "Prior Quarter Avg". The issue I'm running into is that I need the "Prior Month Avg" measure to be based on the last record date of the "Volumes[Date]" table. 

Here is the example code for the "MTD Daily Avg" calc:

MTD Daily Avg = averagex(DATESMTD('Date'[Date]),CALCULATE(sum(Volumes[Volume])))

The Volume values are reflected in barrels per day, which makes the average calculation difficult. Any thoughts?

[v-pnaroju-msft]

Hi ExcelWizard18,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution, as this helps the broader community.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi ExcelWizard18,

We are following up to see if the information we shared helped solve your problem.
If you have any more questions, please feel free to reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi ExcelWizard18,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @lbendlin, for your response.

Hi ExcelWizard18,

We appreciate your question posted on the Microsoft Fabric Community Forum.

From what I understand about your issue, I have attached a screenshot and a sample pbix file that may help you solve the problem:

If you find our answer useful, please mark it as the accepted solution and give kudos. This will help other members who have similar questions. If our response does not solve your problem, please share sample data that fully shows your issue or question, in a usable format (not as a screenshot). Make sure the data does not include any private or unrelated information. Also, please mention what result you expect from the sample data.

If you have more questions, feel free to ask the Microsoft Fabric community.

Thank you.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...