Forum Discussion

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Revenue and Expenditure Table Variance

So I attached two dummy files since I cannot attach the real files.  I have a table in Power BI that has the sales revenue by operating year and then I have a table in Power BI that has the expenses....
Need Help
BILASolution's avatar
BILASolution
Icon for Solution Specialist rankSolution Specialist
8 years ago

JMWDBA

 

Additionally, I think that error is because of there are different Center's names for the same Center Code in Revenue table. Check it.

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
8 years ago

As I look at it, this is indeed the case.  When a location may have moved in a previous operating year, it kept the same number but took on the name of where it moved.  For accounting purposes, the name in effect for that operating year remained instead of being overridden even if it was in the same city and just moved to a different address.  

 

Then I have discovered that two of our locations have no code at all.  So truly now the only thing consistent between both tables is the name of the location within an operating year.   What do I do with this?

  • BILASolution's avatar
    BILASolution
    Icon for Solution Specialist rankSolution Specialist
    8 years ago

    JMWDBA

     

    I need your real data to do a better analysis

    • JMWDBA's avatar
      JMWDBA
      Icon for Advocate II rankAdvocate II
      8 years ago

      That becomes my conundrum.  I cannot obtain clearance to transmit the actual file.  Is it possible to leave out the Location Description and just use the Codes?  The codes I know are unique but something like Jacksonville - Main could have once been called Jacksonville - Mayport last year and the year before that it was Jacksonville - Matthews.  So the name changed but the code always remained the same.