Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello everyone,
I am fairly new to power BI and I'm sure that the following question is a rookie mistake. Im currently working with Power Bi desktop. My issue is I'm trying to add a calculated column using the function EOMONTH to calculate the last date in the month. The problem is that the function is not being recognized in the formula bar. I also tried it with an IF function, but it's like it's just viewing the function as text rather than a function if that makes any sense?.. I'm not sure if I deselected something to cause the formula bar to not recognize the functions as functions and instead as text. I was able to successfully write an IF function shortly before I started experiencing this issue. I would greatly appreciate some insight on this. Thank you.
@Khoward1607 , You should be able to create a column like
End of month = eomonth([Date],0)
May sure ut column not measure
You can refer this video for beginners - https://www.youtube.com/watch?v=cN8AO3_vmlY
Thank you for your help. I saved the video you referred me to. I found that once I completely exited power BI and brought my report backup I was able to type functions once again not sure if it was just a bug?
Again thank you so much for your time I appreciate your advice.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 82 | |
| 71 | |
| 50 | |
| 46 |