I have used the below function to generate column J and when use power query to generate report for this column the function not work properly please check and advise



in excel workbook

=IF(AT2="","",IF(AU2<>"",AU2-AT2,TODAY()-AT2))

in my power query i have used the below query

if [Hold From] = null then null else if [Hold released date] <>"" then [Hold released date]-[Hold From] else DateTime.LocalNow()-[Hold From]

returned custom column values as null instead of respective values.