Forum Discussion
JMWDBA
Advocate II
Advocate IIRevenue 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....
I tried to simulate a case like yours, and this is the results...
BILASolution
Solution Specialist
Solution Specialist
I tried to simulate a case like yours, and this is the results...
JMWDBAAdvocate II
Advocate IIYess!!! Its 99% there. Now that I am no longer getting errors, what I notice its doing for the Sum of Revenue is taking the SUM across all 5 years worth of data I have in the revenue file which totals $527,899,365.06 instead of revenue just for the corresponding location. It's also doing the same thing for Expenses.
I am going back through the pbix you provided to see if I missed something because I see that yours actually takes it for the specific location.