Forum Discussion
Tablename Variable
Hi I have a number spreadsheets one generated from our CRM and the others from Planner. The CRM spreadsheet has a column called ID. Each of the Planner spreadsheets are named after an ID value. I...
Diddeous , Not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
In case you have set ids in one table(Table1 - with unique Id) and set of id in another table(Table2) and you want to find if table2 has all ids or not.
Join Table 1 to Table 2 in 1- M
and create a measure like if( count(Table2[ID])+0 =0, 1, blank())
Plot this with IDs of Table 1