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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Advanced find exclude this fiscal period and last fiscal period

(0) ShareShare
ReportReport
Posted on by 5

Is it possible in Advanced find to exclude this fiscal period and last fiscal period
Ex: You get the report today: August 19, 2021 is it possible to exclude data within this quarter and last quarter data and retrieve the data from last last quarter

Breakdown of what I want to achieve

Get Report: August 19, 2021
3rd Quarter: exclude data
2nd Quarter: exclude data
1st Quarter: Retrieve Data

Is this possible in Advanced Find?

I have the same question (0)
  • Suggested answer
    Nya Profile Picture
    29,060 on at

    Hi,

    Unfortunately, it cannot be achieved with Advanced Find.

    If you'd like to create a report based on Fiscal Year and your organization has Power BI licenses, it is recommended to achieve your request with Power BI, which has very powerful reporting capabilities.

    Here's a briefing article on Sorting Data by Fiscal Year:

    Sorting Data by Fiscal Year in Power BI - PowerObjects | Dynamics 365 | PowerObjects

  • Ram Prakash Duraisamy Profile Picture
    2,287 on at

    Hi turtlebear,

    You should be able to do this if you set your Fiscal Year Setting to have quarters.  You do this under Settings--> Business Management-->Fiscal Year Settings

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 22 Super User 2026 Season 1

#1
Suriyanarayanan V Profile Picture

Suriyanarayanan V 22

#3
Encore Business Solutions Profile Picture

Encore Business Sol... 14

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans