Convert stored date to serial number date

[onedayover]

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

[HarishKM · Accepted solution]

@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  

[onedayover]

@HarishKM, thank you ... this is exactly what I was needing to achieve

[amitchandak]

@onedayover , Not very clear 

one is to add an index column https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

of you can create a column like

date key = format([date], "YYYYMMDD")

[onedayover]

@amitchandak, thank you for your replay and my apologies. What I was trying to convey was that I needed to convert a date such as 28/05/2019 to a serial number format like 43613.