Forum Discussion
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...
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
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.