Forum Discussion
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...
Anonymous , check if the attached file after signature can help
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...
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
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.