Forum Discussion

NirH_at_BITeam's avatar
NirH_at_BITeam
Frequent Visitor
7 years ago
Solved

Convert DateTime into Date in Query Editor using M function

Hi,   I'm looking for the right function to replace a DateTime to a Date in M. The challenge is that the DateTime length may vary based on month and day number, so for example I have: 8/5/2017 12:...
Data Modeling
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
7 years ago

Hi NirH_at_BITeam, 

 

You can go to Query Editor, click on the left icon of the column name, then select the Date to change DateTime type to Date type. The corresponding M query uses the Table.TransformColumnTypes() function. 

 

 

 

Best Regards,
Qiuyun Yu