Values from another not related table

[szervos]

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 · Accepted solution]

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]

Thank you!that will do the trick!