Forum Discussion
Calculated Table
Hi, We have 2 tables and the requirement is we have to compare date from table 2 with date from table 1 and provide output as calculated table. Thank you in advance. Table 1 - country rate ...
NaturalinnerJoin on date column will work for you.
Or you can simply create one column in first table.
Column=Lookupvalue(table2[date],table2[Date],table1[date])
Filter out this column to is not blank.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.