Excel power query help
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.
|