Forum Discussion
Date.IsInPreviousNDays M code question
You can either:
Add 1 step to your first query: select the value, so the output of the query will be 1 value and you can replace the 2 in your function by <NameOfYourFirstQuery>.
Or
Replace the value 2 in your function by: Table.FirstValue(<NameOfYourFirstQuery>).
I would prefer the first option.
Yes (in answer to the original question), provided the outcome is a value in the range of a 32-bit integer value.
If the value is a negative integer, the result will always be false.
Otherwise the first argument of the function should be a date/datetime or datetimezone field.
[Text Range] doesn't sound like such.
Edit: note that he comparison is always against the date of the last data refresh.
[Text Range] is a column of dates in this example.
Actually, I read some of your previous posts that led me to how I can Query the results from an Excel table that has an Excel slicer.
Using the Aggregate function in Excel it's possible to create a single row table in Power query based on the number of days a user selects.
I'm trying to determine if its possible to plug that result into the M function.