Forum Discussion
marabeda
Helper I
Helper ICreate a calculated columns from 2 tables
Dear Community, I have these 2 tables: Table1 Table2 The relationship between tables is many-to-many with column Client My objective is to have two calculated columns in Table1 where ...
It's better version
We concatenate by two columns here
Source file: https://1drv.ms/u/s!AiNTN-Usixb7h9JTE5bZIVEGbQGfUQ?e=2PK2tO
technolog
Super User
Super UserBefore this
Colonna giorno calc = IF(NOT(ISBLANK(RELATED('Table2'[Cliente']))), "OK", "NOT OK")
You can create calculated table
Table2Unique = DISTINCT('Table2'[Cliente])
and then use
Colonna giorno calc = IF(NOT(ISBLANK(RELATED('Table2Unique'[Cliente']))), "OK", "NOT OK")