Forum Discussion
Gopinath_iyer
4 years agoHelper II
help in calculation
Hi All, I need you help/suggestion in acheiving the below result. my data has multiple rows for a product with same amount repeating. How would i show the category wise sum of amount but each pro...
amitchandak
4 years agoSuper User
Gopinath_iyer , Create a measure like
sumx(summarize(Table,[Category],[Product],[Amount]), [Amount])
or remove duplicate in power query
- Gopinath_iyer4 years agoHelper II
Thanks creating measure worked