Creating a formula column in Dataverse that shows the last day of the quarter

(0) Share

Report

Posted on by CU01111400-0

Good afternoon,

I am trying to create a date column which will show me the last day of the quarter we are currently in. I have tried multiple examples but I can't seem to make it work.

The latest I found and tried to tweak was :

DateAdd(
    DateAdd(
        Date(Year(UTCNow()),
             (RoundUp(Month(UTCNow())/3,0) * 3) - 2,
              1
        ),
        3,
        TimeUnit.Months
    ),
    -1,
    TimeUnit.Days
)

But according to Dataverse "Date" doesn't exist. There is only DateAdd and DateDiff.

Is there any solutions to this?

Many thanks in advance

Margaux

Categories:

Power Apps component framework

All responses (1)

Answers (0)

Suggested answer

bscarlavai33 340 on at

Like (0)

Report

Creating a formula column in Dataverse that shows the last day of the quarter

Unfortunately this isn't possible with a formula column at the moment. Formula columns have limited functions that can be used which are listed here - https://learn.microsoft.com/en-us/power-platform/power-fx/formula-reference-formula-columns.