Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with modeling - duplicate values

Folks, need a help. I receive from a system the following table: Engagement ID Valeu USD Status 12345 100 Active 12345 200 Active 12345 -400 Active 12345 600 Active 12345...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    You can use group by in the edit queries, then advance and add multiple column(Screenshot below)

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey Anonymous 

 

You can use the following DAX expression once the data has been imported into PBI:Consolidated Table = 

SUMMARIZE(
    EngagementID, EngagementID[Status],
    EngagementID[Engagement ID],
    "Value USD", SUM(EngagementID[Value USD])
)

 

 

 

 

 

 

 

Click HERE to access my PBIX file if needed.