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 your prompt response. I appologize for the inconvinece , The sum in the summary table has beeen incorrect. I have updated the summary table as below

 

Price Range    Units traded

 below 100       100

101 to 200      824

201 to 300       0

301 to 400       400

401 to 500      500

above 501      2541 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • 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