Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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".
Solved! Go to Solution.
@erhan_79 , a new column like
if([creation date] <eomonth(today(),0),"Actual Month","Next Month")
Make < as <=
[created date] <= eomonth(today(),0)
@erhan_79 , a new column like
if([creation date] <eomonth(today(),0),"Actual Month","Next Month")
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
Make < as <=
[created date] <= eomonth(today(),0)
dear @amitchandak ;
thank you very much , it is working very well , you always help us thanks for your kind supports
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |