Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago
Solved

CALCULATETABLE

Hello community,   Is there a way to accomplish this:   CGJOBS Reduced = CALCULATETABLE(CGJOBS;CGJOBS[JOB]=VALUES(realocJOBS[JOB]))   I have big table CGJOB and I want to reduce it  (I mean fi...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Fcoatis

     

    try:

    CGJOBS Reduced = CALCULATETABLE(CGJOBS;CGJOBS[JOB] IN VALUES(realocJOBS[JOB]))

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Fcoatis

 

try:

CGJOBS Reduced = CALCULATETABLE(CGJOBS;CGJOBS[JOB] IN VALUES(realocJOBS[JOB]))

  • Fcoatis's avatar
    Fcoatis
    Post Patron
    7 years ago

    Thank you very much!

     

    Thats exactly what I was looking for.

     

    Best Regards