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 All,
This is my first try of Power BI, trying to figure out many new things, and get stuck with calcuating the datediff field.
The issue is that it won't read my date field automatcially from the table, and I checked the field "ASOFDATE" and "DUEDATE" are both the date type. so I manually entered the two but recived the below warning message. ( I watched some introduction vedio online, in theroy, the field options will pop up when entering the formula, but I don't see any option... )..
Anything critical I am missing here? Any help is apperciated.
Thank you,
Flora
HI @Anonymous,
It will be help if you share some detail content about your issue. For example: screenshots, formula, sample data...
Regards,
Xiaoxin Sheng
Can you post the error message you were receiving, the DAX calculation you are attempting, as well as a sample of how the data is structured in the table? Without this, there's not much anyone can do to help.
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!