Forum Discussion
Solved
Cannot convert value 'Monday' of type Text to type Number.
Hello, I am trying to get the day name from a date but it keeps giving me the error below Cannot convert value 'Monday' of type Text to type Number. I am using the formula: FORMAT('V...
Hi nakin,
Based on my test, you could try this formula:
Number = FORMAT('Views'[Created].[Day],"DD")Result:
You can also download the PBIX file to have a view.
Regards,
Daniel He
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi nakin,
Based on my test, you could try this formula:
Number = FORMAT('Views'[Created].[Day],"DD")Result:
You can also download the PBIX file to have a view.
Regards,
Daniel He
Hi v-danhe-msft
Thanks for this, finally I used the WEEKDAY formula and it seems to work.
Thank you !