Sales Vs return comparison

[sanjoyleo]

Hi ,

I have 2 tables, Transaction and Retun (see below)  . Now I want to show for each Month what was the Transaction_Amt Vs Return_Amt .

When I used "Line and Clusterd Column Chart" I got the 2 Bar --1 for Sales and one for Return Amont (in "Column values" I kept 2 filed's Sum separately)  ..

but in Shared Axis , if I take Transaction Year-Month , Then Return_Amt for each month became avg accross all month/year..

 In Shared Axis ,If I take Return table's Year-Month , then Transaction_Amt for each month is showing as Avg.

So I feel we need to use single Month-Year colum which will split the Transaction Vs Return both. 

How can I use single Date column for both table ? Basically I want to show Transaction_Amt Vs Return Amonth on date wise(month-Year)

Transaction				Return
Year	Month	Transaction_Amount_Total		Year	Month	Return_Amount
2017	May	23.37		2017	May	7.79
2016	May	19.5		2016	May	15.75
2016	June	634.37		2016	June	634.37
2015	January	1984		2015	January	5
2015	February	2658.4		2015	January	7
2015	May	51.5		2015	January	20
2013	August	29		2015	January	22
2013	November	2328.71		2015	January	23.5
2013	December	4701.7		2015	January	26
2012	July	71.5		2015	January	42
2011	December	12		2015	January	120
2010	January	3599.5		2015	January	250
2010	February	9893.77		2015	February	10
2010	March	4		2015	February	13.5
2010	April	103		2015	February	21
2010	May	11340.6		2015	February	25.2
2010	September	8209.9		2015	February	33.6
2010	November	100.5		2015	February	34
2010	December	93.25		2015	February	34.5
2009	December	365165.38		2015	February	40.1

[jthomson]

You need a calendar table that you can relate both of your current tables to. I don't know if there's an underlying date in your existing tables orn just a year and month column, but I'd make one if there isn't (fairly straightforward to do so using DATE and your year/month columns, just stick in a dummy day if needed).

[sanjoyleo]

Both the tables's column is [datetime] Type ,like  2010-05-25 21:29:13.077  ..

So are you sating to create a new Table with 3 column .. one with date , next is for Transac_Amt , and the 3rd column as Return_Amt ..

and then populate this table from those 2 table ?

I am new to Power BI , started 20 days back . Please help !

[sanjoyleo · Accepted solution]

Got the solution from below page:

http://akvelon.com/how-to-show-values-from-two-tables-on-one-power-bi-visualization/

Thanks for help!