web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

How to have filter criteria in a view to show last rolling 12 months

(0) ShareShare
ReportReport
Posted on by 26

I need to create a view that would show the Billed in last Rolling - 12 months.

How can I do this?  Not sure what option to pick in the filter area of the view.  Thank you.

I have the same question (0)
  • AriaConsulting Profile Picture
    2 on at

    Hi, which D365 app are you using? And does billed=invoiced?

  • Suggested answer
    Gustavo Longo Profile Picture
    on at

    Hello USA80,

    Hope you are well.

    Based on column that you would like to filter, you can choose a query relational operator for last months or year and achieve your need.

    See these articles:

    docs.microsoft.com/.../search

    docs.microsoft.com/.../advanced-find

    Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 58 Most Valuable Professional

#2
#ManoVerse Profile Picture

#ManoVerse 42

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 38 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans