Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How to Set a date column as date (have 2 date column in the same dataset)

Hi, I have 2 columns in 'Power Query '  recognize as Date, but when I am in the visualization/working space only one column have a 'Date' icon beside it. 

(one colunm called date, then have another called fdate which calculated based on date in power query )

How can I set fdate also as 'Date' column?

this is Power Query view, i can see: both are 'Date' format/type

Screenshot 2020-04-22 at 17.15.06.png

then without doing anything just apply and loading then I find this in my data model when i close the power Query editor

fdate, become this (same as another datecolunm), and I do check the 'column tool' find it indeed showing as a date format

Screenshot 2020-04-22 at 17.14.36.png  Screenshot 2020-04-22 at 17.33.44.pngScreenshot 2020-04-22 at 17.33.55.png

then when I in the visualization work space, my fdate column is not recognized as date , which (maybe) creates lots of trouble when i use time intelligent function.  

Screenshot 2020-04-22 at 17.14.23.png 

 

Anyone can give suggestion I can make fdate as 'Date' column at the work space?

 

Thank you!

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Pretty sure that just means that Power BI Created an automatic hierarchy for Date but not for fdate.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

Pretty sure that just means that Power BI Created an automatic hierarchy for Date but not for fdate.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.