Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
My datasource looks like below where I have Duplicate rows. I would like to sum the Days column for duplicated rows. For below data the sume will be 9 for Name1 and 3 for Name2. I am not sure how to achieve this? Any help is appreciated! Thanks in advance for your time!
Solved! Go to Solution.
@new0220
Drag and drop the Name field onto a Table visual and add the following measure next to it.
Total = SUM ( TableName[Days] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @new0220 ,
you can do it like this:
Sum of Days = SUM('Table'[Days])
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Thank you!
@new0220
Drag and drop the Name field onto a Table visual and add the following measure next to it.
Total = SUM ( TableName[Days] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you. It worked
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |