Forum Discussion
sanjoyleo
Helper I
8 years agoSales Vs return comparison
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...
- 8 years ago
Got the solution from below page:
http://akvelon.com/how-to-show-values-from-two-tables-on-one-power-bi-visualization/
Thanks for help!
sanjoyleo
Helper I
8 years agoBoth 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
Helper I
8 years agoGot the solution from below page:
http://akvelon.com/how-to-show-values-from-two-tables-on-one-power-bi-visualization/
Thanks for help!