Unable to view the "Name of the day " in power query editor( Date & Time Column)

[bhanu_bhanu]

i everyone,

I'm currently working in Power Query Editor in Power BI and facing an issue with a Date & Time column. I'm trying to extract the name of the day (like Monday, Tuesday, etc.), but I'm unable to see it as an option or result in the transformation steps.

I've attached a screenshot for reference to help explain the issue visually.

Can someone please guide me on what might be going wrong or how I can get the day name to appear?

Thanks in advance!

[v-hashadapu]

Hi @bhanu_bhanu , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @bhanu_bhanu , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @bhanu_bhanu , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.

[BeaBF · Accepted solution]

@bhanu_bhanu Hi! Try with right click on the column and then:

You'll obtain:

If it's ok, please accept my answer as solution.

BBF