Skip to main content


Advanced ranges of a query in D365FO view

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"
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()))
Step 3: Build the solution and viewed the output through table browser.
Chaitanya Golla


*This post is locked for comments