I have a column with the click flow of a user on a specific day:
BUT, When activities repeat themselves, it becomes impossible to visualise or group the data. I would like to replace repetitive strings (activities) with one single string:
Dax only please, because this is a calculated column.
Some help would be much appreciated!
Go to Solution.
@Analyst1991 What do you change your formula like this?
VALUES ( ActivitiesTable[Activity Type] ),
ALLEXCEPT ( ActivitiesTable, ActivitiesTable[UserId], ActivitiesTable[Date] )
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
View solution in original post
@Analyst1991 , three functions in power query should to it
Proud to be a Super User!
@amitchandak thank you, but I'm working with calculated columns, so unfortunately Power Query won't solve my problem.
@Fowmy That worked! Thank you!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.