dax

[Anonymous]

i want to show count of customers whose has done some retailing and which is > 0, if the retailing is >0 then it should count the values as 1. i want to show how many times that customer has done retailing i.e >0.
Sheet name is 'PSR', columns as Customer_code, Retailing.

also i want to display the same for the last 3 month and that should be dynamic i.e Rn its oct so it should take data of july aug and sept.

[Uzi2019]

Hi @Anonymous 
You forgot to add your data. please provide data screenshot of your input and expected output in excel..

Thanks

[Anonymous]

[Uzi2019]

hi @Anonymous 
please provide sample data and your expected output like calculated value.

[danextian]

Hi @Anonymous ,

Please post a sample data (not an image) and from that sample data your expected result.  This sticky post should serve as a guide: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message