monthly customer sale

[abc_777]

Dear Concern,

I have total customer sales column

I need to find out customer minimum purchase 5000 dollar every month (January, February, March .....)

can i do measure or calculative column as i have (quantity sold- Return quantity) * Unit price

Regards

[Msta]

Add more detail it's currently not clear what you want to achieve. Can you post some sample data and your desired output?

[abc_777]

I want list of Unique or distinct customers who purchase more than 5000 dollar on every month

in attached image I have prvcustID, then Total Sale to Customer column and in slicer I have year and month under year.

please ignore the column name RANKX this  this time in my image

Thanks

[abc_777]

@Jihwan_Kim 
would you be able to help me out for this issue please?

[abc_777 · Accepted solution]

resolved