Forum Discussion

edavila's avatar
edavila
Icon for Helper II rankHelper II
9 years ago

Amounts not showing Correctly

I have 2 tables one that has all the dates from 2 years listed and also the name of the month, week and year   and I create a report as table to show the Balance sheet for the company at a certain ...
Need Help
Show and Tell
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

edavila

 

You can combine in Power BI Desktop.

 

Import your both tables and go to Edit Query to do this. --Select thr action "Append Queries"

 

 

edavila's avatar
edavila
Icon for Helper II rankHelper II
9 years ago

Victor

 

to clarify do I need to create a new table and then append both tables and let me tell you that I change the direction of the relationship for FS2016 to both and FS2017 has a single when I try to change it will give and error