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?