Forum Discussion
Create a Collum Based on another Table
I have two tables: Table 1 have a collunm production-date. DATEPRODUCTION PRODUCTION 2023-06-12 3 2 In Table 2, i have 3 collunms, the first collum is the round, the secon...
Hi Anonymous
Please try the following DAX in a new column in table 1ROUND = VAR __DATE = Table1[DATEPRODUCTION] RETURN CALCULATE( MIN( Table2[ROUND] ), __DATE >= Table2[START_DATE] && __DATE <= Table2[END_DATE] )
Hi Anonymous
Please try the following DAX in a new column in table 1
ROUND =
VAR __DATE = Table1[DATEPRODUCTION]
RETURN
CALCULATE( MIN( Table2[ROUND] ),
__DATE >= Table2[START_DATE] &&
__DATE <= Table2[END_DATE]
)it work exactly like i wanted, thank you a lot!!!