Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
my data looks like below:
month | value |
jan'18 | 1 |
feb'18 | 1 |
mar'18 | 1 |
apr'18 | 1 |
Here monh column is in text type and when I try to change to date type, I get all errors. How do I fix this?
Kinldy help.
Solved! Go to Solution.
@sam_nik12345 , Try the other option suggested
Column = DATEVALUE("01-"& left([month],3) & "-" & RIGHT([month],2) )
@sam_nik12345 , I would prefer to create a date column like
DATEVALUE("01 " &[Month])
or
DATEVALUE("01-" &left([Month],3) & "-"& right([month],2))
Hi @amitchandak
I am getting error while creating a custom column with the formula-
= DATEVALUE("01 " &[Month])
@sam_nik12345 , Try the other option suggested
Column = DATEVALUE("01-"& left([month],3) & "-" & RIGHT([month],2) )
The other table is as below, on which I am getting error with this formula. week column format is text type. Kinldy help.
week | value |
3-Apr-18 | 1 |
10-Apr-18 | 1 |
17-Apr-18 | 1 |
24-Apr-18 | 1 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |