Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sales performance tracker

Hi everybody,  I have the following challenge.   The following table is available to me for our sales submit. Submitted Date Name Designation Region Status 10/10/2021 ABC Jr. Corp Sal...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Join the second Table with first Table  and also join first table with date table and have month year column

    Target Score=

    Sumx(Table1, related(Table2[Target])

     

    Variance = Countrows(Filter(Table1[Status] = "Approved")) - [Target Score]

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Join the second Table with first Table  and also join first table with date table and have month year column

Target Score=

Sumx(Table1, related(Table2[Target])

 

Variance = Countrows(Filter(Table1[Status] = "Approved")) - [Target Score]

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thank you for replying me. But I want to show you, why the variance get the wrong calculation? Can you provide me again? I using Merge Queries as new, from first table to second table with LeftOuter join.