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 IIOk I see why its doing totals for both instead of by location. It wont establish the relationship because it needs at least one of the tables to have distinct values.