Days empty

[Chene]

Hi 

I need to work out how long a sales request has not been added to a presales resource since being created

[Anonymous]

Hi @Chene ,

Any updates?

Best Regards,
Eyelyn Qin

[Vijay_A_Verma]

If there is a list of presales request, other list is creation date - How will I know whether a presales request has been allocated or not? There should be some column which tells me this. 

Assuming that all presales request has not been allocated, then you can use following formula to know calendar days

= Duration.Days(Date.From(DateTime.FixedLocalNow())-[Creation Date])

[Chene]

Hi Vijay

Thank you so much for your reply.  The data comes from a MS List.  The one list is the presales name (which should only be where there is not presales selected) and the other one is the creation date.  I need to work out how many days has a presales request been non allocated.  Does that help you at all.  If not please let me know what you need.

[Vijay_A_Verma]

Can you post some sample data (without confidential/sensitive one)?

How to Get your Question Answered Quickly - https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523