Forum Discussion

KatkaS's avatar
KatkaS
Post Patron
5 years ago
Solved

Keep first value

Hello,   I have a simple excel sheets with names and dates when they logged in an application. I need to keep (count) only their first log-in, delete the rest (or keep, but just count the first lo...
  • fhill's avatar
    fhill
    5 years ago

     

    In Query Editor, try the Group By Feature -> Advanced to Select the MIN Login (by Email) and COUNT of Rows.

     

    After that, you can take the GROUPED DATA into a simple chart.

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

KatkaS - Seems like:

Measure =
  VAR __Month = MAX('Calendar'[Month])
  VAR __Year = MAX('Calendar'[Year])
  VAR __Table = SUMMARIZE(ALL('Table'),[Name],"First",MIN([Logged in]))
RETURN
  COUNTROWS(FILTER(__Table,YEAR([First])=__Year && MONTH([First])=__Month))
KatkaS's avatar
KatkaS
Post Patron
5 years ago

Thank you, Greg, but I'm afraid this is too advanced for me. You mentioned MAX('Calendar'[Month])

 - do I need to create new table with periods and create relationship between the User login table..?