Forum Discussion

jthomson's avatar
jthomson
Solution Sage
8 years ago

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's avatar
    sanjoyleo
    Helper I
    8 years ago

    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 !