#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Issue with Power Query editor/Data model-Excel 2016 | Meg Mika | Excel | 0 | 11-12-2019 01:05 PM |
Do I need a power query for this one? | shabbaranks | Excel | 5 | 04-10-2019 03:29 AM |
Issues Using Power Query file in Excel 2016 and then in 2013 | bld9936 | Excel Programming | 0 | 02-27-2017 12:50 PM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |