Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aggregate, Sort the data -> Calculate score

Sample pbix file link: https://we.tl/t-TM2i36iWpY   I'm struggling with creating a PairScore column as shown in the screenshot below. Consider this table as a chat room log data where user A and B...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , In case you need pairscore

You can try measure like

countx(allselected(Table), Table[roomID] = max(Table[RoomID]) && Table[Date] <= max(Table[Date])) *.5

 

otherwise

Can you please share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Here is a sample data! https://we.tl/t-920BuxuX7U 

I tried your method but it looks like the measure doesn't take the date column... 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Create a date column from created_at, is has a time stamp

     

    Date = [created_at].date

    or

    Date = date(year([created_at]),month([created_at]),day([created_at]))

     

    You can try the same formula with correct column names

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak  Thanks but I found another issue with that method. It needs to have both date and time, but ".date" makes it all the same time.. 

      Would you please help? Here is a pbix file link! https://we.tl/t-TM2i36iWpY 

      Thank you so much.