Forum Discussion

Apollo71's avatar
Apollo71
New Member
2 years ago
Solved

Group By Query

Hi,   I am trying to create a Power BI form with the following data, but group by serial number and showing the latest service date and corresponding name of the engineer.   Serial number    Serv...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    here is a workaround for you

    try to create a rank column

    = Table.AddColumn(#"Changed Type","Rank",each Table.RowCount(Table.Distinct(Table.SelectRows(#"Changed Type",(x)=>x[SD]>[SD] and x[SN]=[SN]),"SD"))+1)

     

    then filter rank =1

     

     

    at last you can delete rank column

    pls see the attachment below

kpost's avatar
kpost
Solution Sage
2 years ago

What is your data source?  Is it all coming from a single place or no?

 

If it is coming from multiple places then you may have to look at the connections between your data tables.

Can you upload a sample .pbix file with some bogus data (if the data is confidential) that simulates the problem? 

It's working fine for me, assuming all of the data is coming from a single document:

 

https://files.catbox.moe/m03b75.pbix

//Mediocre Power BI Advice,  but it's free//

  • Apollo71's avatar
    Apollo71
    New Member
    2 years ago

    Thanks,

     

    Managed to do what I needed by creating a rank column and grouping by the highest date