Forum Discussion

Mandi-Holt's avatar
Mandi-Holt
Frequent Visitor
4 years ago
Solved

Combine values from different rows to allow duplicates to be removed

I am fairly new to using Power BI and Power Query and have a table that has been created from doing a left outer join on a WeatherReading table and a CustomWeather table. The new table has multiple ...
Need Help
  • Mandi-Holt's avatar
    Mandi-Holt
    4 years ago

    Just to update that this issue has been solved externally to this group. In case anyone else is looking to do the same then here's a couple of solutions.

    Add a calculated table:

    Table1 = 

    SUMMARIZE (

    AllWeatherReadings,

    AllWeatherReadings[VslReadingId],

    “Earthquake”, MAX ( AllWeatherReadings[Earthquake] ),

    “TRV”, MAX ( AllWeatherReadings[TRV] ),

    “Temp”, MAX ( AllWeatherReadings[Temp] )

     

    The alternative is in Power Query to use the Group By, select advanced and add grouping by the VslReadingId column, name the columns the same, set them to Max and ok.

     

    Thank you.

Mandi-Holt's avatar
Mandi-Holt
Frequent Visitor
4 years ago

Just to update that this issue has been solved externally to this group. In case anyone else is looking to do the same then here's a couple of solutions.

Add a calculated table:

Table1 = 

SUMMARIZE (

AllWeatherReadings,

AllWeatherReadings[VslReadingId],

“Earthquake”, MAX ( AllWeatherReadings[Earthquake] ),

“TRV”, MAX ( AllWeatherReadings[TRV] ),

“Temp”, MAX ( AllWeatherReadings[Temp] )

 

The alternative is in Power Query to use the Group By, select advanced and add grouping by the VslReadingId column, name the columns the same, set them to Max and ok.

 

Thank you.