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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |