Forum Discussion
rs281105
11 months agoRegular Visitor
Power query problem while extracting day from date by add column option
Power query problem while extracting day from date by add column option , ih this the whole window is not fitted upto screen of pc /laptop and while extracting day name from date we can't able to get...
- 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!
v-nmadadi-msft
11 months agoCommunity Support
Hi rs281105
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you