Not Billed customer

[prabhuk]

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 ) )

[V-lianl-msft]

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.