Skip to main content

Advanced ranges of a query in D365FO view

 
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"
 
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

Comments

*This post is locked for comments