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.
Hi All
I am converting field Text to Date by using Dax Function "DateValue" but i got above message could you please advice proper solution. In My table i have a data '#' in date column then i relpace as null value ,after that i applied Date value function getting issue
Solved! Go to Solution.
@Anonymous , As per @amitchandak suggestion you need to add column name in else condition so this would be your idea code as suggested.
Column =
IF (
'Table (2)'[Date] = BLANK ()
|| 'Table (2)'[Date] = "#",
BLANK (),
DATEVALUE ( 'Table (2)'[Date] )
)
Output:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
@Anonymous , Try a new column like
if([Date] ="" | | [Date] ="#", blank() , datevalue([Date]) )
Hi Amitchandak,
i appied the above syntax but getting empty data
@Anonymous , As per @amitchandak suggestion you need to add column name in else condition so this would be your idea code as suggested.
Column =
IF (
'Table (2)'[Date] = BLANK ()
|| 'Table (2)'[Date] = "#",
BLANK (),
DATEVALUE ( 'Table (2)'[Date] )
)
Output:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |