web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
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 Profile Picture Chaitanya Golla 17,225
 
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