Forum Discussion
Help with Date Calculated column
Hi all,
I am trying to create a calculated column where in if date is equal to "2019/11/24" then print Static otherwise the date value. I am using the below two logic but keep getting an error - "Expression that yield variant date-type cannot be used to define calculated column"
The date column is of type "Date/time" with format "dd-mm-yyyy hh:min:sec(G)" - Please help
Column = If(Table1[date] = Date(2019,11,24),"Static",Table1[date])
Column = If(Table[date] = DateValue("2019-11-24"),"Static",Table1[date])
Thanks,
Vikash
Try like
Column = If(Table1[date] = Date(2019,11,24),"Static",format(Table1[date],"dd-mm-yyyy hh:mi:ss"))
for full set of options refer
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
5 Replies
Try like
Column = If(Table1[date] = Date(2019,11,24),"Static",format(Table1[date],"dd-mm-yyyy hh:mi:ss"))
for full set of options refer
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Thanks very much amitchandak , It worked. I now understand that the return type has to be same datatype.
Anonymous , Appreciate if you can mark the solution. It will help others to find the solution easily
Go into Power Query (Transform Data button on home ribbon) and verify that is truly a date column. I bet it shows ABC/123 as the column data type. Click that and change it to date, or date/time.
Just because visually it looks like a date doesn't mean Power BI will see it as a date. It must actually be the Date data type.
Hi Anonymous ,
This error is reported because your calculated column returned two types of data: text & date.
So, you can refer to amitchandak 's answer.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
