Forum Discussion

szervos's avatar
szervos
Regular Visitor
8 years ago
Solved

Values from another not related table

Hello Community!

 

I have a table called Date which holds the dates from 1/1/2000 till 1/1/2020.

I have a filter in the page to filter the date range (e.g. from 1/1/2018 to 22/1/018).

Then I have another table where I want to store in a column the MIN and MAX date according to the filter above.

The two tables are not related and cannot be related.

 

How can I achieve the target?

 

Thank you in advance!

  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi szervos,

     

    Based on my test, it is not possbile to meet your requirement. However we can create a table visual to work around. 

     

    max = CALCULATE(MAX('Table'[Column]),ALLSELECTED('Table'))
    min = CALCULATE(MIN('Table'[Column]),ALLSELECTED('Table'))

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi szervos,

     

    Based on my test, it is not possbile to meet your requirement. However we can create a table visual to work around. 

     

    max = CALCULATE(MAX('Table'[Column]),ALLSELECTED('Table'))
    min = CALCULATE(MIN('Table'[Column]),ALLSELECTED('Table'))

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

    • szervos's avatar
      szervos
      Regular Visitor
      8 years ago

      Thank you!that will do the trick!