Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Target vs actuals month basis

Hello    I'm trying to do some visuals for some projects I'm working on, where I have a Target for the project which is static, and a monthly update of what has been invoiced.    So far I've adde...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Make sure both table are joined to common project table. No need to join target to date table

     

    remaining example 

     

    sumx(project, calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )

     

    or

     

    sumx(values(project[project]) , calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Make sure both table are joined to common project table. No need to join target to date table

 

remaining example 

 

sumx(project, calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )

 

or

 

sumx(values(project[project]) , calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )