Forum Discussion
dax
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.
4 Replies
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
Hi Anonymous
You forgot to add your data. please provide data screenshot of your input and expected output in excel..
Thankshi Anonymous
please provide sample data and your expected output like calculated value.
