Share
Report
4We 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...
All responses (
Answers (
