Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate value using IF condition across multiple tables

I have data across 3 tables.   First table has the mapping codes for the other 2 tables AIMSCode CHRISCode HealthService 1000 8000 Alfred Health 2000 9000 Monash Health   Secon...
  • VahidDM's avatar
    VahidDM
    5 years ago

    Hi Anonymous 

     

    Please download this file and let me know if it does not cover your request:

    https://gofile.io/d/ebakXo

     

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

    Appreciate your Kudos ✌️!!

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

assume you have create one to many replationship between those tables, and try this code

NewMeasure=MAX(BLANK(),MAXX(Table1,CALCULATE(SUM(Table2[Value])-SUM(Table3[Value]))))