topic Data type Error in DAX Commands and Tips

Data type Error

SushmaReddy — Thu, 10 Mar 2022 07:08:54 GMT

Hi Team,

Written this code to get data from 2 different columns(_Date &_Time)

PTS =

date(Year(T1[_Date]),month(T1[_Date]),DAY(T1[_Date]))

&" "&

time(HOUR(T1[_Time]),MINUTE(T1[_Time]),SECOND(T1[_Time]))

I am getting the below error

**Cannot convert value '21-02-202204:31:56' of type Text to type Date**

Please help me resolve this

amitchandak — Thu, 10 Mar 2022 11:18:36 GMT

T1[_Date] + T1[_Time]

date(Year(T1[_Date]),month(T1[_Date]),DAY(T1[_Date]))
+
time(HOUR(T1[_Time]),MINUTE(T1[_Time]),SECOND(T1[_Time]))