Forum Discussion

Harishankar's avatar
Harishankar
New Member
2 years ago
Solved

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