Forum Discussion

Kaustubhhh's avatar
Kaustubhhh
New Member
2 years ago

Filtering repetetive rows in an sql database

Hi all, I have one dataset with column names- "tool no", "wear offset" , "tool length", "tool life" , "time stamp". In this dataset rows are coming per second. There are different tool nos who have...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

You could group on Tool and Offset, using the GroupKind.Local parameter in the Table.Group function. It'll give you a new group for each change in Offset.

 

--Nate

  • Kaustubhhh's avatar
    Kaustubhhh
    New Member
    2 years ago

    Hi Nate, 

    Can you please elaborate about the same as I am a beginner in Power BI.

    It will great if you can write down the query for this dataset