Forum Discussion
Dataset With NA Date and 2 Date Column Inquiries
Hi guys, I have a dataset with 2 date columns, Created Date and Closed Date. The Closed Date is having NA. Below is my questions: 1. Since Date data type is not allow to have NA, thus...
Hi,
why dont you just replace NA values with null in the Power Query and keep it as a Date column.
Dont separate the tables and make things complicated.
Hi, I have try to replace the null with NA for the Closed Date but it shows error when PBI is loading after I saved and closed the Power Query Editor. The reason is Date data type cannot have missing value and NA.
Thus, I separate it but not sure is this a good pratice.