Creating numerical reference to date

[1241pm]

Hi, I have a table with a column of dates ranging from september 2016-dec 2018. I would like to create a column/measure that will allow me to reference each date to a numerical number in the order reported. For example, sept 2016=1 , oct 2016=2 .... dec2018=28. Thank you so much for your time. 

[v-chuncz-msft · Accepted solution]

@1241pm,

You may take a look at the following post and use DATEDIFF Function accordingly.

http://community.powerbi.com/t5/Desktop/Calculate-Sales-first-year-second-year-etc/m-p/451157#M20890...