Incremental Refresh Parameter

[Anonymous]

I have a question about RangeStart and RangeEnd parameters.
In my case I need to create these parameters according to MAX date and Second MAX date. The range is specified as the difference between the MAX date and previous (second) MAX date. I thought that I can create two calculated columns first, and then I can use these calculated columns in parameter creation. But of course I'm not sure if it's right or not.
I've tried to write query on parameter creation but when I choose the Query option on parameter page, it's not active. I can not write anything on it. Do you have any solution suggest?
Thanks.

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Assume i have a table which has dates from 2019/1/1 to 2019/12/31.

This table (called "table") needs to configure incremental refresh.

Firstly create two new blank query.

max date query

let
    Source = List.Min(#"table"[date]),
    #"Converted to List" = {Source}
in
    #"Converted to List"

second max date query

let
    Source = Date.AddDays(List.Max(#"table"[date]),-1),
    #"Converted to List" = {Source}
in
    #"Converted to List"

Secondly, create two new parameter,

select "query" for "selected value" option, then select "second max date" query for "range start" parameter, 

for "range end" parameter, select "max date" query undre the query list.

Finally, go to report view, you could select the start and end date from the "drop-down" icon.

the current value is entered randomly.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.