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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a table with 2 date fields:
there are no null values in both fields.
I'm creating a calculated table with:
Distinct recs= Summarize('main data', 'main data'[name],'main data'[FINAL EXP],'main data'[document_create_date])
but for some reason the fields are seen in a different way in the new "Distinct recs" table (I've renamed the fields):
both fields types look the same:
Anyone has seen this odd behaviour before?
TIA
Solved! Go to Solution.
Hi @df123445
Are you meaning why does created not have the Auto Date/Time field generated?
If you have joined on this field to say a Calendar table that will have turned it off.
Blog on auto date/time
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
Limitations
https://learn.microsoft.com/en-us/power-bi/guidance/auto-date-time
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Thanks a lot
Hi @df123445
Are you meaning why does created not have the Auto Date/Time field generated?
If you have joined on this field to say a Calendar table that will have turned it off.
Blog on auto date/time
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
Limitations
https://learn.microsoft.com/en-us/power-bi/guidance/auto-date-time
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.