Get Limit value from table 2 by comparing date from table 1

[Anonymous]

Hi,

I have 2 tables like below:

I want to ftech the limit1, limit2, limit3 by comparing date & Site Name from table 1 with date range in table 2.

i.e. It should check the date range in which the date fits; also, if the site name matches, return the values from that row.

[sanalytics · Accepted solution]

Hello @Anonymous 

Assuming you want to compare Table1[Date] with Table2[StartDate] and Table2[EndDate] range.

If it is then please get the below solution

Create a calculated column by writing below DAX

Limit 1 =

CALCULATE(

    MAX( Table2[Limit1] ),

    FILTER(

        Table2,

        Table1[SiteName] = Table2[SiteName] &&

        Table1[Date] >= Table2[StartDate] &&

        Table1[Date] <= Table2[EndDate]

    ) )

Please find the below screenshot

Hope it will help you.

Regards

sanalytics

If it is your solution then please like and accept it as solution

[Anonymous]

Thanks @sanalytics 🙂

[sanalytics]

@Anonymous 

Glad, it worked. Would appreciate if you like the solution.

Regards

sanalytics