Forum Discussion
Calendar
Hey,
maybe the phrase "after expanding ..." from my 1st post has been too short :-)
Expand the List to new rows in your new column by hitting the "double arrow" icon.
After this you will be able to convert the data type of the column into the data type date
Regards,
Tom
I will try tomorrow and keep you un touch
Regis
Hello Tom
It works great to create list field, but it has been automaticaly convert in text...i cannot convert back to date and the link with a calendar table failed, because calendar stays in date format
Do you already have such an issue please ?
Regards
Hey,
using my pbix i have no problem to convert the the text field to data type date, neither using Power Query nor DAX.
I recommend do the conversion already in Power Query ... mark the new column and select
Menu: Transform --> Date & Time column --> Date only
Maybe you will receive errors, but here you the possibility to investigate further.
Hopefully this gets you started.
Regards,
TomHello,
I really don't know why transform option unavailable
Look at the screen attached if you have any idea it will be a great help
Regards
Regis
Hey,
maybe the phrase "after expanding ..." from my 1st post has been too short :-)
Expand the List to new rows in your new column by hitting the "double arrow" icon.
After this you will be able to convert the data type of the column into the data type date
Regards,
Tom