topic Re: Return Value is text need value as Date in DAX Commands and Tips

Return Value is text need value as Date

jbakerstull — Mon, 05 Jun 2023 18:53:06 GMT

Hi all,

I using the following formula in a column to return max start date per client. The formula works as intended but value is text based, I need it to be date value. Any help would be apperiated.

LatestEntryDate = CALCULATE (

MAX ( Client[Start_Date] ),

ALLEXCEPT ( Client, Client[Clients Personal ID] ))

Re: Return Value is text need value as Date

tamerj1 — Mon, 05 Jun 2023 19:04:04 GMT

Hi jbakerstull

It depends. But try to wrap it with DATEVALUE function

LatestEntryDate =
DATEVALUE (
CALCULATE (
MAX ( Client[Start_Date] ),
ALLEXCEPT ( Client, Client[Clients Personal ID] )
)
)

Re: Return Value is text need value as Date

jbakerstull — Mon, 05 Jun 2023 19:07:05 GMT

Thanks for the reply, following error message populated when I place in Datevalue

Re: Return Value is text need value as Date

jbakerstull — Mon, 05 Jun 2023 19:12:35 GMT

Added Datevalue populated the folling error message:

Too many arguments were passed to the DATEVALUE function. The maximum argument count for the function is 1.

Re: Return Value is text need value as Date

jbakerstull — Mon, 05 Jun 2023 19:22:32 GMT

The error is now gone. I tested the created column against the Client (tbl) start date using formula below. I believe the error has been fixed. I'm just trying to fiqure out how to test the fix.

Formula tested was

Match Dates = if(Client[ClientlatestEntry]=Client[Start_Date],1,0)

Re: Return Value is text need value as Date

tamerj1 — Tue, 06 Jun 2023 05:51:53 GMT

jbakerstull

Please try

Match Dates = IF ( [ClientlatestEntry] = MAX ( Client[Start_Date] ), 1, 0 )