Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
9 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
9 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
9 months ago

or creat new columns in Current

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