Notifications
Announcements
No record found.
Hi
I created my desired data model in formula designer in Electronic Reporting ,
then created a table record of "TaxTrans" table , i want to use where clause for "TaxTrans" field ( where taxtrans=3)
How can do it?
Best regards,
Zahra
Hi Zahra,
In the model mapping designer, edit the root properties. You can enable "Ask for query". Whenever this configuration is run it will pop the Query form in which you can select records to include.
you can also add some function to filter the data using WHERE function, the above option is more user friendly and can be chosen at runtime.
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-functions-list-where?toc=/dynamics365/commerce/toc.json
Hi Zhara,
If you are in the formula designer than you should see a functions section on the right hand side.
In this section there is a where clause available.
Simply select an item in your model and select the edit button then you should see this.
Ludwig
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 559 Most Valuable Professional
André Arnaud de Cal... 464 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
