Forum Discussion

alvin199's avatar
alvin199
Icon for Helper III rankHelper III
2 years ago

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...
Need Help
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
2 years ago

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. 

 

 

alvin199's avatar
alvin199
Icon for Helper III rankHelper III
2 years ago

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.