Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |