Forum Discussion

ExcelWizard18's avatar
ExcelWizard18
Regular Visitor
1 year ago
Solved

Prior Month Daily Average

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 bas...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

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.