Forum Discussion
onedayover
Helper III
Helper IIIConvert stored date to serial number date
Hi, I am wanting to add a new column in my table that converts a stored date into a serial number. Can anyone help me with how to do this? Thanks
onedayover Hey you can use below dax fuction but first create a coloum then write these dax function.
Datevalue = DATEVALUE(financials[Date])
once it is create then convert it to a decimal number .
Kindly refer below image.Kindly refer these documentation as well for your reference .Datevalue dax function
HarishKM
Super User
Super Useronedayover Hey you can use below dax fuction but first create a coloum then write these dax function.
Datevalue = DATEVALUE(financials[Date])
once it is create then convert it to a decimal number .
Kindly refer below image.
once it is create then convert it to a decimal number .
Kindly refer below image.
Kindly refer these documentation as well for your reference .Datevalue dax function
onedayoverHelper III
Helper IIIHarishKM, thank you ... this is exactly what I was needing to achieve