Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count uniqe values existing in two variable tables

Hi, I have two connected tables.   The first one (Table1) cointains sales data with unique client ID and date among other things. The second one (Table2) is a simple table with dates. I'm trying a...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Try this

    Countrows(union(table1,table2))

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks a lot!

 

I don't know if you meant Countrows(union(table1,table2)) or Countrows(union(currMonthColumn, lastMonthColumn))

But the second one worked as expected 😁

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have given generalized answer so have to replace it by using existing table or virtual tables which you stored in visual.

 

You replaced it correctly.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.