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 ;
TODAY = 17.06.2020 and Month is June
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".
Solved! Go to Solution.
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
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Visit our Community Blog for articles, guides, and information created by fellow community members.