cancel
Showing results for
Did you mean:
Highlighted
Post Partisan

## Formula Help

Hi there ;

i need your support about creating below formula , let me explain ps what i need ;

i have table as below and i have "creation date"  column , i would like to create a new column which one 's name is " Month Data" , i want that the new column will work like that ;

Scenario :

TODAY = 17.06.2020 and   Month is June

Rules :

if the "creation date"   includes before dates than today  ; " Month Data "  will seem   " Actual Month".

İf the "creation date"  is  equal to today  ;  " Month Data "  will seem   " Actual Month".

İf the "creation date " is after than today but includes June days ;   " Month Data "  will seem   " Actual Month".

İf "creation date"  is after than today but  not includes  June days    ; " Month Data "  will seem   " Next  Month".

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IX

## Re: Formula Help

@erhan_79 , a new column like

if([creation date] <eomonth(today(),0),"Actual Month","Next Month")

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IX

## Re: Formula Help

Make < as <=

[created date] <= eomonth(today(),0)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

5 REPLIES 5
Highlighted
Super User IX

## Re: Formula Help

@erhan_79 , a new column like

if([creation date] <eomonth(today(),0),"Actual Month","Next Month")

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Post Partisan

## Re: Formula Help

dear @amitchandak  ;

thank you very much , it is working very well , you always help us thanks for your kind supports

Highlighted
Post Partisan

## Re: Formula Help

dear @amitchandak  ;

now i noticed something when the creation date is last day of the month , on new column it writes "next month " too , but infact it must write " actual month " for 30.06.2020 too.Could you pls check it too

Highlighted
Super User IX

## Re: Formula Help

Make < as <=

[created date] <= eomonth(today(),0)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Post Partisan

## Re: Formula Help

thanks @amitchandak

now everything is ok

Announcements

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors
Top Kudoed Authors