Forum Discussion
Removing Duplicate Rows in the same month and for same user
Hi Everyone!
I am trying to use a visualization that is looking for a single row per user per month but my data may have multiple rows of the same user in the same month. How can I combine the 'value' column in instances where there is multiple rows with the same user in the same month??
I appreciate the help!!
Thanks,
Chris
2 Replies
Hi harozi2
It depends on your data model, Can you share a sample of your data table in a text format with the result that your are looking for?
you can use SUMMARIZE dax formula to summarize your table.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Hi harozi2,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
