Date DAX Function is different

[Anonymous]

Hello

Maybe I missed something with an update? My DATE() DAX functions are showing Errors now. Normally DATE functions are like this DATE(YYYY,MM,DD) now when I want to use it, it wants two values for Year, Month and Day DATE(YYYY,YYYY,MM,MM,DD,DD) 

Normally after entering the year and then comma, you will be prompted to enter the month, but not in my example below.

Does anyone know why?

Thanks

[v-lid-msft]

Hi @Anonymous ,

I think it is a dispaly error of hint, the date and time function works fine on my side, Could you please try to use a card visual to show the measure:

DATE = DATE(2019,9,1)

BTW, what is your verios of Power BI Desktop? Could you please upgrade it to the lastest version to see if this unexpected display happened again.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi

Thank you for replying. I am using the most recent 64 Bit version. I uninstalled Power Bi and reinstalled it. But still getting this problem. The first photo below is the normal way of writing the Statement and I get the error as shown. The second photo is when I enter DATE(2019,2019,09,09,01,01)  and I get October 1st as the result.

Thanks

Joe

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

I am sorry that we can not reproduce your issue, but I found a workaround in this post, please try to add a space after each number and see if you can get the correct answer.

DATE = DATE(2019 , 9 , 1)

This should get the result of 9/1/2019 12:00:00 AM

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you! that works.

[Anonymous]

It's the same for the TIME function too