Forum Discussion

cdawidow's avatar
cdawidow
Icon for Helper III rankHelper III
6 years ago

Format numeric to date YYMMDD

Hi guys, I was wondering how best to convert my dates from their numeric value to date?  Currently I get numbers set up like so YY-MM-DD  example, 200217.   Any easy way to do this in dax or power...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

cdawidow - You can use the FORMAT command. You can also change the format in the ribbon under Measure Tools or Column Tools. There is also display formatting as discussed in Chelsie Eiden's Duration - https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

 

Could also use SUBSTITUTE to replace "-" with "".

 

Those are all DAX solutions. I am sure there are Power Query ones too. For example, you could split that column on "-" and then concatenate it back together the way you want. Or, heck, just replace your "-" with "" in Power Query editor.