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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

How did you get the results of 298, 456 etc.?  Show the calculation - be very clear.

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".