Forum Discussion
dates fields from calculated table shown in a different way
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
Hi Anonymous
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
2 Replies
- AnonymousNot applicable
Thanks a lot
- SamWiseOwl
Super User
Hi Anonymous
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