Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2021, 01:50 AM
ganesang ganesang is offline Excel power query help Windows XP Excel power query help Office 2016
Competent Performer
Excel power query help
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft