Forum Discussion
Calculated Date Column Showing Underlying Date
This is a strange issue. In a Table, I have a Last Received date column. Due to a quirk in the database, this column may contain invalid dates - 0001-01-01 or 9999-12-31. These dates, of course, ...
Anonymous,
It's best to do transformations in SQL or Power Query. Do you have the ability to write custom SQL? If not, you could create a custom column in Power Query:
if List.Contains({#date(1,1,1), #date(9999,12,31)}, [Last Received to Stock]) then null else [Last Received to Stock]
Anonymous,
It's best to do transformations in SQL or Power Query. Do you have the ability to write custom SQL? If not, you could create a custom column in Power Query:
if List.Contains({#date(1,1,1), #date(9999,12,31)}, [Last Received to Stock]) then
null
else
[Last Received to Stock]