Power Query Duration Between Two Dates

**mielkew27** · 04-17-2017, 04:15 AM

Hi All,

I have this formula =IF([@[Target Re-Submission Date]]="","",IF(TODAY()-[@[Target Re-Submission Date]]<=-1,"",TODAY()-[@[Target Re-Submission Date]]))

How can I write this in Power Query?

Thanks,
Mielkew

**MarvinP** · 04-17-2017, 01:09 PM

Hi mielkew,

I think you are looking for the answer given on
https://social.technet.microsoft.com...rum=powerquery

If we could see the data it might make more sense.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**mielkew27** · 04-18-2017, 01:20 AM

Hi Marvin,

Please see attached Sample Workbook.

Thanks,
Mielkew

**MarvinP** · 04-18-2017, 01:31 AM

Hi,

You need to use the Add Conditional Column dialog in Power Query. Here is a video showing how to use it.

https://www.bing.com/videos/search?q...DB&FORM=VRDGAR

There is a dropdown for a date and "Today" is one of the selections.

Also - you might need to add a new column that has the date of "Today" in it. Then in using the Add Conditional Column dialog you can stipulate "Today" as a column reference.