Forum Discussion

aatish178's avatar
aatish178
Helper IV
2 years ago
Solved

Using date field from another table to main table for filtering of data

Hi Everyone,

I have a requirement where I have two tables. One table consists of a date column which I have to use for filtering of data from another(Main) table in the calculated measure expression. The main thing is there is no relationship between two tables. 

below is the sample dataset.

table 1:

Date for filtering
01 January 2020
01 February 2020
01 March 2020
01 April 2020

 

Main Table:

Emp IDEmp nameDOJ
e1Oliver01 January 2020
e2George01 February 2020
e3Noah01 March 2020
e4Arthur01 April 2020
e5Harry01 May 2020
e6Leo02 May 2020
e7Muhammad10 May 2020
e8Jack18 May 2020

 

Here in Main Table I want only those records where DOJ IS GREATER THAN MAX of Date for filtering(from table 1) i.e., data for emp e5 to e8 alone. Can someone please help me

quantumudit Anonymous 

 

Regards,

Aatish

Need Help
Show and Tell
Tips and Tricks

7 Replies

    • aatish178's avatar
      aatish178
      Helper IV
      2 years ago

      Dear Ashish Sir,

      Thanks for your help. However in the attached file I could see you formed a relationship between 2 tables. I want to know whether the implementation is possible without forming a relationship and just using date field from filter table may be as a variable to use in the calculated measure of main table in order to get filtered data

       

      Aatish

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        You are welcome.  why do you not want to create a relationship between the 2 tables?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi aatish178 ,

     

    If you need to filter by a specific time, you can refer to the following results, but of course if you only need the maximum value, just change the expression:

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.