Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
10 months ago
Solved

Containsstring and Count

Hi good day  Can anyone help me on my calculated column, i have two table that connected. I want to count the number of Job.   DESIRED OUTPUT   Table Connection    JC Count ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    9 months ago

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

AllanBerces's avatar
AllanBerces
Post Prodigy
10 months ago

Hi Ahmedx thank you for the reply but the new calculated column we required is for the current table.

 

Ahmedx's avatar
Ahmedx
Super User
10 months ago

or creat new columns in Current

L = SUMX(RELATEDTABLE('MAIN_DATA TABLE'),[L-Count])
Q = SUMX(RELATEDTABLE('MAIN_DATA TABLE'),[Q-Count])