Forum Discussion

Ragnar_Raghu's avatar
Ragnar_Raghu
New Member
6 years ago

Sumif between two tables

Hi All,   I have two Tables   Table 1 has hourly price of electricity for each day   Date               hour-block   Price 01/04/2017     0 to 1            200 01/04/2017     1 to 2          ...
Need Help
baronraghu's avatar
baronraghu
Helper III
6 years ago

Hi Ashish,

 

Thanks for the solution.

 

Just wanted to understand, How did you merge the tow tables- price and unit traded. I used inner join function but was unable to get it

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

You are welcome.  See the join type in the Query Editor.  I have used "All from Both".

  • baronraghu's avatar
    baronraghu
    Helper III
    6 years ago

    Hi Ashish,

     

    I did the Full join merging and found similar column from table 2 getting also added in the merged table. Could you please share the trick. Tje sample pbi file u shared does have any duplicate columns (date/hour block)

     

    I tried to remove the columns but it gtends to impact the data set in the merged table

     

     

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      These images should clarify

      • baronraghu's avatar
        baronraghu
        Helper III
        6 years ago

        thanks ashish... hope this should work