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
    • JMWDBA's avatar
      JMWDBA
      Icon for Advocate II rankAdvocate II
      8 years ago

      I am getting one error but I am thinking because I probably should have given more dummy data in the file.  

       

      The error message when creating the Sales Center column in the Center Code created table says: "A table of multiple values was supplied where a single value was expected."

       

      The real file has 150 locations that repeat by operating year.  There are other fields in the report but not really relevant.  The ones provided in the dummy file are the ones that I really focus on. 

       

      Any thoughts?

       

       

      • 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.