Unanswered

Make the Excel Formulas work with Calculated fields

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to get execel formulas to work with CDS calculated fields , is there any way to make thses formulas to work with CDS?

ODD, YEAR, INT, SUMIF, ROUNDUP, RIGHT, MONTH

Any help would be appreciated , I have complex formulas that need to solved , Please check one such example , Let me know if it possilbe with CDS

Here $AL6 is a date field

=IFERROR(
    IF(
        OR(
            $BN6 = "",
            $BN6 = 1900
        ),
        "",
        IF(
            YEAR(
                $AL6
            ) < 2018,
            "Q1-18",
            ( "Q" &
                INT(
                    ROUNDUP(
                        MONTH(
                            $AL6
                        ) / 3,
                        0
                    )
                ) & "-" &
                RIGHT(
                    YEAR(
                        $AL6
                    ),
                    2
                ) )
        )
    ),
    ""
)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

leventg 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you every checked content at this link? It might help.
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-if

Was this reply helpful? Yes No
TuongDoan 573 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Calculated column doesn't support full PowerFX set of function.

Please read this: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#function-types

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!

Was this reply helpful? Yes No