Forum Discussion
Not Billed customer
Dear All,
I am using the below code to find new customer billed for specific period. now i need to modify this code the list of not billed customer for a specific period.
Kindly help
New Customers Sales =
VAR CustomerTM = VALUES(SALES[CUSTOMER] )
VAR PriorCustomers = CALCULATETABLE( VALUES(SALES[CUSTOMER] ),
FILTER( ALL( 'Time'[Date]),
time[Date] > MIN( 'Time'[Date]) - [Time Frame Value] &&
'Time'[Date]<= MIN('Time'[Date]) ) )
RETURN
CALCULATE( [Ttl Revenue] ,
EXCEPT( CustomerTM, PriorCustomers ) )
1 Reply
Hi prabhuk ,
Please provide a brief overview of what the result is trying to achieve and then post data, relationships, formulas and expected output. If you post in this way, if there is an answer to be had, you will get an answer.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
