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've below table which has only two columns (Place & Value) wtih few rows, for each rows I wanted to add hardcoded date as 01,01,2020 date column. How to achieve this?
Solved! Go to Solution.
@Anonymous , new column as
new date = date([year],1,1)
Thanks! that worked so perfectly.
Also I've only Year Column how to make date out of it.
Example:-
Year
2020
2018
Expected
Date
1,1,2020
1,1,2018
How to achieve this. Many Thanks
@Anonymous , new column as
new date = date([year],1,1)
@Anonymous , add a new column
new column = date(2020,01,01)
This will be in date format
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |