Advanced ranges of a query in D365FO view
Chaitanya Golla
17,225
Share
ReportHi,
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.
Regards,
Chaitanya Golla
*This post is locked for comments