Month to Date Computation

(0) Share

Report

Posted on by chachaK

Would like to know how to implement the following computation field in my portal.

MTD = (cumulativeSales/DIFFINDAYS( Now()-startMonthDate))*TotalMonthdays.

The challenge is obtaining the startMonthDate from the CurrentDate and endMonthDate from the CurrentDate at any given point and time.

Please help.

Categories:

Power Apps portals

I have the same question (0)

All responses (4)

Answers (0)

Sort by

oliver.rodrigues 9,475 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi, you need to populate that date field in the on create/update of a record is that your scenario?

have you looked at calculated fields? https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes

if you need to calculate on the load of the page, you will need to apply custom JS and add your logic in there

Was this reply helpful? Yes No
chachaK 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks @OliverRodrigues perhaps i didn't capture my requirement well in the above.
I just need to know how to compute/Get StartofMonth from a given date (lets say 23/04/2021) as well as EndofMonth from the same date.
Thanks

Was this reply helpful? Yes No
Fubar 8,497 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Need to be clear as to where you are needing it - i.e. is it needed in a custom Web Template = Liquid or is it just needed to when the page loads = JavaScript

In JavaScript you can use the Date objects .setDate() and/or .setMonth() functions

// Where d = a date object d.setDate(1) // sets the date to the first day d.setDate(0) // sets the date to the last day of the previous month d.setMonth(d.getMonth()+1, 1) // sets the date to the first day of the dates current month + 1

Was this reply helpful? Yes No
oliver.rodrigues 9,475 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

at what moment do you need to know that?

Was this reply helpful? Yes No