Forum Discussion

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago
Solved

Though experiment - dynamic date table based on date MIN/MAX?

Hi all,   I generally create my date tables using something like the following, so I can set start and end parameters, and customize from there.     [ Spoiler ]     However, I had a thoug...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    Hi RMDNA,

    Based on my test, you could use the query parameter to get your result:

    Here is a sample table

    Create two queries to fetch the max/min value:

    Max query:

    let
    Source = List.Max(#"Table1"[Column1]),
    #"Converted to List" = {Source}
in
    #"Converted to List"

    Min query:

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

    Use the parameter to pass the query:

    Result:

    Hoep it could help you.

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi RMDNA,

Based on my test, you could use the query parameter to get your result:

Here is a sample table

Create two queries to fetch the max/min value:

Max query:

let
    Source = List.Max(#"Table1"[Column1]),
    #"Converted to List" = {Source}
in
    #"Converted to List"

Min query:

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

Use the parameter to pass the query:

Result:

Hoep it could help you.

 

Regards,

Daniel He