Forum Discussion

trevb's avatar
trevb
Advocate II
9 years ago

Datevalue incorrect conversion

Blast, just realised what my issue was here!   I have a date in english form that is stored in a Parameters table so I can access it from PBI Desktop.  The original parameter is A date in power que...
trevb's avatar
trevb
Advocate II
9 years ago

Hi Alex,

 

That is actually the root of my problem.  Those settings are all correct but DateValue interprets the date as an American date anyway.

 

 

AlexChen's avatar
AlexChen
Microsoft Employee
9 years ago

Hi,

 

Can you give out a screenshot on your control pannel settings just like what I showed above?

 

Also please paste a sample code using DateValue and its execution result.

 

Best Regards

Alex

  • trevb's avatar
    trevb
    Advocate II
    9 years ago

    This is the measure I am using modified so it works ;-)

     

    Funding Period Start = Date(2015,8,1) //DATEVALUE(LOOKUPVALUE(Parameters[Value],Parameters[Name],"Funding Period Start")) -conversion error means this has to go on hold

     

    In the end I had to comment out the function and Force a block date.  The value in Parameters is "1/8/2015"

     

    The value I was receiving from this conversion in english UK was  8/1/2016 i.e. 8th January 2016.  I've included an image of my time settings for you.

     

  • gyumike's avatar
    gyumike
    New Member
    4 years ago

    Hi AlexChen,  do we have answer or solution for the issue from latest PBI desktop version? Thanks Mike