How to get the first value of a query and pass it as the current value of a parameter?

[AlanCruz]

Hello everyone, I have two queries, one is my calendar table, and the other is a parameter that I use to define what date my calendar starts from. Currently I manually change this value.

What I want to do is, use another query that comes from a json file, which returns just one row.

I need the start date to change in my calendar table whenever the value of my "Query1" changes.

I want to use this value as current value of my "LastDays" parameter, how do I do that?

[AlanCruz]

@watkinnc , I searched for this solution for months, trying to use value as parameter and such, and you solved it with just a simple formula.

Thank you very much. You rock.

[watkinnc · Accepted solution]

= Table.FirstValue(TableName)

--Nate