Forum Discussion
htsvhwave
Helper II
Helper IIReturn a value from another tabel based on multiple conditions
Hi I have to tables, in my first tabel i want to return a value from the second tabel. I need to look up the amount of vacation left for december. In this example i have only shown one user howev...
Hi htsvhwave ,
You can follow the steps below to get it:
1. Create the relationship between Table 1 and Table 2 base on the field [User ID]
2. Create a calculated column as below in Table 1 to get it
Vacation left = CALCULATE ( SUM ( 'Table 2'[Amount] ), FILTER ( 'Table 2', 'Table 2'[Date] = EARLIER ( 'Table 1'[Date] ) ) )Best Regards
Hi htsvhwave ,
You can follow the steps below to get it:
1. Create the relationship between Table 1 and Table 2 base on the field [User ID]
2. Create a calculated column as below in Table 1 to get it
Vacation left =
CALCULATE (
SUM ( 'Table 2'[Amount] ),
FILTER ( 'Table 2', 'Table 2'[Date] = EARLIER ( 'Table 1'[Date] ) )
)
Best Regards