Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@onedayover Hey you can use below dax fuction but first create a coloum then write these dax function.
Kindly refer these documentation as well for your reference .Datevalue dax function
@onedayover Hey you can use below dax fuction but first create a coloum then write these dax function.
Kindly refer these documentation as well for your reference .Datevalue dax function
@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")
@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.
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |