Forum Discussion
Power query problem while extracting day from date by add column option
- 11 months ago
Hi rs281105 You’re right, I understand your frustration. This is a Power BI UI issue the "Name of Day" is only about 70% visible at the bottom in Laptop but 100% visuble in Large Monitor. In your case, it might be even less.
Root Cause: There is a high probability you laptop has 125% scale
if you adjust your device display setting to 100% it will visible perfectly
Go to your PC Settings -> Display Settings -> Scale & Layout -> Scale 100%
However, Here is the m-code to get the Name of Day from your Date column
= Table.AddColumn(#"Changed Type", "Day Name", each Date.DayOfWeekName([Date]), type text)Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
Hi rs281105
As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.
Thanks and regards
Yes the answer is some where some how satisfying thank you