MonthStart(today(), ) and Monthend(today(), )

[taylor_jesse]

Can someone please help me understand clearly what the monthstart() and the MonthEnd() function means in plain English.

Also what if instead of month start I want to use days what function will that be.

for instance what will monthstart(today(),-5). and  monthend(today(),-2). represent. My confusion is what day exactly or how does it calculate the month with the integer values.

Thank you

[sankvag7]

Hi @sunny_talwar ,

How can I get sum(revenue) for first day of the current month and sum(revenue) for the first day of last month in set analysis?