Forum Discussion

Regular Visitor

8 years ago

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('Views'[Created].[Day];"DDDD")

Any help would be appreciated!

Thanks

v-danhe-msft
8 years ago
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.
https://www.dropbox.com/s/hrbr3str316wtn6/Cannot%20convert%20value%20%27Monday%27%20of%20type%20Text%20to%20type%20Number..pbix?dl=0

Regards,
Daniel He

5 Replies

Seward12533
Solution Sage
8 years ago
Just loose the .day.

FORMAT('Views'[Created];"DDDD")
- nakin
  Regular Visitor
  8 years ago
  Hi,
  I have used the formula without the .day FORMAT('Views'[Created];"DDDD")
  
  Now I have this error:
  
  Cannot convert value 'Thursday' of type Text to type Number.
  
  :smileysad:
  - Anonymous
    Not applicable
    8 years ago
    The FORMAT function takes a number (or date, because dates are just funny numbers) as its input. You can't give it the word "Monday" as its input. You have to give it an actual date.
v-danhe-msft
Microsoft Employee
8 years ago
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.
https://www.dropbox.com/s/hrbr3str316wtn6/Cannot%20convert%20value%20%27Monday%27%20of%20type%20Text%20to%20type%20Number..pbix?dl=0

Regards,
Daniel He
- nakin
  Regular Visitor
  8 years ago
  Hi v-danhe-msft
  
  Thanks for this, finally I used the WEEKDAY formula and it seems to work.
  
  Thank you !

Related content