1,267
I have a custom entity, EntityA, which has a start date and and end date. I would like to have a (calculated) field which tells me if TODAY is between start and end. So I would like to know if the post is "active".
I have exported CRM data to PowerBI and can make a new column with Yes or No value with this DAX expression:
Active = IF('EntityA'[Start]<=TODAY()&&'EntityA'[Slut]>=TODAY();"Yes";"No")
Is it possible to have the same thing /something similar in CRM?
*This post is locked for comments
Thank you. Clean solution. No code.
I can even hide the fields and just use them for reporting.
You might also do it with two calculated fields:
- For the first field, you can use "Now()" formula
- For the second field, you can, then, define conditions:
IF FIRST_FIELD > Start AND FIRST_FIELD < END
SET SECOND_FIELD=Yes
ELSE SET SECOND_FIELD = No
(You would need two fields since you can't compare to "Now" directly)
in my opinion not directly, but you can create a custom filed to hold the value and a plugin on the retrieve and retrievemultiple messages to fill custom field with the logic you described
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (