Get Summary by Customer

[sekinod]

My Data Table like this

Every customer has a unique NoteDate and Amount but several Post Dates. So in the power bi report, I want to get a table visual like below.

The amount is group by NoteDate when adding date columns from calendar table to visual, and it should be done by measure.

Thank you

sample.pbix 

[Fowmy · Accepted solution]

@sekinod 

Try the following measure:

Amount Measure = 

SUMX(
    VALUES(Target[Customer]),
    CALCULATE(MAX(Target[Amount]))
)

---------------------------OR--------------------------------

Amount Measure = 
SUMX(
    SUMMARIZE( Target , Target[Customer] , "_Amount", MAX(Target[Amount] ) ),
    [_Amount]
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[sekinod]

Dear @Fowmy ,

Thank you for help.