Forum Discussion
Distinct Count For More Than One Value
Hi! I am trying to calculate days since an item was last purchased. I know for the datediff function I can not have the same date multiple times. However, I have had multiple different Items purchase...
Hi Anonymous ,
Try below calculated table.
Table 2 = SUMMARIZE('Table','Table'[Date],'Table'[Item])If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
In the Query Editor, select both columns, right click and select "Remove Duplicates".
Ashish_Mathur
Super User
Super UserHi,
In the Query Editor, select both columns, right click and select "Remove Duplicates".
Thank you!