Forum Discussion
Harishankar
2 years agoNew Member
Power BI
I have two columns 1)NAME containing 300,000 names which includes repetition and I have 2) EXPENDITURE columns containing the expenses done by the NAMES over the years. Help me to group or combine the names and all their expenses in a single row.
For example:
For Example Result
1 A 200 1 A 500
2 B 100 2 B 350
3 A 300 3 C 100
4 B 250 4 null 300
5 c 100
Hi,
Create a Table visual and drag the Name column there. Drag this measure to the visual
Measure = sum(Data[Amount])
Hope this helps.
3 Replies
- Ashish_MathurSuper User
Hi,
Create a Table visual and drag the Name column there. Drag this measure to the visual
Measure = sum(Data[Amount])
Hope this helps.
- HarishankarNew Member
Thank you
- Ashish_MathurSuper User
You are welcome.