DAX limitations in Formula column

(2) Share

Report

Posted on by CU19092109-0

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)