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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

DAX limitations in Formula column

(2) ShareShare
ReportReport
Posted on by 4

We use Dynamics CRM in our nonprofit to track donors and donations. I'm trying to add a calculated field to the "donations" table that looks at the donation date and lists the fiscal year that gift falls into. To do this, I'd need something like this:

IF(
MONTH('Donation Date') >= 9, 
"FY" & TEXT(YEAR('Donation Date') + 1, "00"), 
"FY" & TEXT(YEAR('Donation Date'), "00")
)

However, I'm finding that there are a lot of limitations to the DAX code you can use in a formula field in D365. MONTH, YEAR, DAY, TEXT, are all functions that apparently are not supported.
Even if I could have it just return the 4-digit year (without the "FY" string), I'd be happy with that... 

I have the same question (0)

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 85 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 57 Most Valuable Professional

#3
Satyam Prakash Profile Picture

Satyam Prakash 49

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans