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.
From M you can pass a parameter but not a slicer selection to replace the hard coded number of days (in addition to a query or formula that returns a number).
Can you give me an example of what the code/function would look like that would be accepted by the Date.ISN.. function?
Any query or function/formula that returns a numeric value could be used in place of a hard coded value. You could also refer it to the value returned by a previous step in the existing query or even a value from a specifc cell.
Based on your description of wanting to use a slicer, you are implying that you want the user to be able to select a value from said slicer and pass that into the filter argument for number of previous days to show. If that is the case, if you provide more detail about what it is you want to return after the slicer selection (an aggregation/calculation or a filtered table), we can assist you with the approach.
[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.
