Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have used a Table.DuplicateColumn command to create a copy of a datetime column (Start DateTime), including specifying the type as date:
#"Duplicated Start DateTime" = Table.DuplicateColumn(#"Previous Step", "Start DateTime", "Start Date", type date)
My question / issue is that the ColumnType option seems to be ignored and the new column appears as datetime (although the 'icon' is date), which I then have to change in another step.
Original columns:
New Column:
Solved! Go to Solution.
Might be just a cosmetic issue, similar to what we had for the longest time with Table.AddColumn *
Note: Specifying a Date column type is futile as Power BI doesn't actually have such a data type. In Power BI everything is datetime behind the scenes.
* on second thought you can replace Table.DuplicateColumn with Table.AddColumn.
Might be just a cosmetic issue, similar to what we had for the longest time with Table.AddColumn *
Note: Specifying a Date column type is futile as Power BI doesn't actually have such a data type. In Power BI everything is datetime behind the scenes.
* on second thought you can replace Table.DuplicateColumn with Table.AddColumn.
Table.AddColumn(#"Previous Step", "Start Date", each Date.From([Start DateTime]), type date)
It's what we call "syntax sugar" - a convenience function that is equivalent (or should be) to a more atomic function.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |