topic Re: Cannot construct data type time, some of the arguments have values which are not valid.. in DAX Commands and Tips

Cannot construct data type time, some of the arguments have values which are not valid..

Anonymous — Mon, 20 Sep 2021 09:49:13 GMT

Hi Guys I am working on a Direct Query table date calculation.

The date calculation working fine on the import mode and not working on DQ mode. What is the reason for this and how to fix it.

Error Message : Cannot construct data type time, some of the arguments have values which are not valid..

Re: Cannot construct data type time, some of the arguments have values which are not valid..

Anonymous — Mon, 20 Sep 2021 09:50:05 GMT

Fowmy

Re: Cannot construct data type time, some of the arguments have values which are not valid..

Anonymous — Mon, 20 Sep 2021 10:13:51 GMT

date(2021, 9, 3)

Re: Cannot construct data type time, some of the arguments have values which are not valid..

Anonymous — Mon, 20 Sep 2021 10:31:38 GMT

Not working

Re: Cannot construct data type time, some of the arguments have values which are not valid..

Anonymous — Mon, 20 Sep 2021 10:36:03 GMT

Most likely because your column that you want to apply the "<=" operator to is not of type date/time whereas DATE(...) is.

Re: Cannot construct data type time, some of the arguments have values which are not valid..

VahidDM — Mon, 20 Sep 2021 11:50:06 GMT

Hi Anonymous

Which type of data do you have in the [DownTime_Start] column? Can you share a sample of your data here?

Appreciate your Kudos✌️!!