Dynamics 365 Community Blogs DAXology (Study about Dynamics AX and Dynamics ... Advanced ranges of a query ...

Advanced ranges of a query in D365FO view

Chaitanya Golla

17,225

Like ( 0 )

Report

Hi,

In this post, we will view the way to provide advanced range values for different query fields of a view.

Please refer to my earlier post to know the definition of view "DAXSalesPriceAgreement"

Different ranges of a query in D365FO view (dynamics.com)

Step 1: I want to display the amounts of different items for the date intervals where fromDate is less than current date and ToDate can be blank or greater than to date. Created ranges for date fields as shown below:

Field	Name	Value
FromDate	FromDate	(PriceDiscTable.FromDate < currentDate())
ToDate	ToDate	((PriceDiscTable.ToDate > currentDate()) \|\| (PriceDiscTable.ToDate == valueUnlimited()))