Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Revenue Count Deduplication

Hi there,   I am dealing with a data calculation situation that I just can't seem to solve. We are in the business of staffing/recruitment and I need to calculate the total revenue being brought in...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Sally's answer should be 6,750.  You may download my PBI file from here.

    Hope this helps.

NaveenGandhi's avatar
NaveenGandhi
Memorable Member
3 years ago

Anonymous 

 

Can you provide the desired output with regards to the sample data you have provided?

 

Thanks,

Naveen

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry about that, here are the desired outputs:

     

    Billings for Q1 (Jan 1 - Mar 31 2023)
    John $                         5,750
    Sally $                         3,000
    Elizabeth $                         2,000
    Wayne $                         3,000
    Randy $                         3,000
    Phil $                         6,750
    Jane $                         1,000
    Joe $                         1,000
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      Sally's answer should be 6,750.  You may download my PBI file from here.

      Hope this helps.