Good afternoon/morning!
I'e been trying this for hours and cannot figure this out. On attached workbook, FILTERED table.
I wish to add 3 new columns.
Column 1 = "ReportDate" value to be selected from a parameter (I can create based upon the your paramater lesson)
Column 2 = DateDiff calculation of (ReportDate) - (ReceivedDate)
Column 3 = "TimeFrame" Column will be based upon DateDiff value =IF(DateDiff <30,"<30",IF(DateDiff <60,">30",IF(DateDiff <90,">60",">90")))
I am totally stuck on only adding the 1st column. Will you please give me a push in the right direction?
Hi Allison,
Noticed that you have a list created by a query, Report Date. Is this dates list you want to append as a new column to your data table?
If yes, you can start by adding an Index column, starting from zero. Next, and a custom column, with this formula:
=try #"Report Date"{[Index]} otherwise null
This will append the list as a new column to your table.
If this is not what you wanted, please clarify, because ""ReportDate" value to be selected from a parameter" is confusing. First, I thought that the entire column must have the same value, from a parameter. I assumed it's the existing Report Date list, that needs to be joined with your data.
If you need to refer to cell C2 in your FilePath sheet, here is the syntax:
Parameter = Excel.CurrentWorkbook(){[Name="rptdate"]}[Content][Report Date]{0}
