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...
wildmight2017Advocate II
Advocate IIYou should ideally create a unique dimension (select distinct code from your tables perhaps with UNION to include all possible scenarios)- and join both tables as a dimension. That should work.