cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ymirza Regular Visitor
Regular Visitor

Missing owners not assigned since X days

I have this table below as an example, I want to show in powerBI report, since how many days from current date has the task not assigned with an Owner. The measure would start with "Not assigned since = "

 

IDFunctionCreated dateStatusOwnersNot assigned since
1IT01-DecIssue ClosedAndy 
2HR02-DecIssue openedCharlie 
3HR03-DecIssue openedCharlie 
4SUM04-DecIssue openedMegan 
5Sales05-DecIssue openedHoggard 
6Marketing06-DecIssue openedOwner not assigned15 days
7Marketing07-DecIssue openedOwner not assigned14 days
8Sales08-DecIssue openedOwner not assigned13 days
9IT09-DecIssue ClosedOwner not assigned12 days
10HR10-DecIssue openedOwner not assigned11 days
11Finance11-DecIssue openedJohn 
12Finance12-DecIssue ClosedJohn 
13Finance13-DecIssue openedOwner not assigned9 days
14Customer14-DecIssue openedAdam 
15Customer15-DecIssue ClosedAdam 
16Customer16-DecIssue openedTommy 
17Customer17-DecIssue ClosedTommy 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Missing owners not assigned since X days

Hi @ymirza

 

You may create a measure as below:

Measure =
IF (
    MAX ( Table1[Owners] ) = "Owner not assigned",
    DATEDIFF ( MAX ( Table1[Created date] ), TODAY (), DAY )
)

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Super User
Super User

Re: Missing owners not assigned since X days

If not assigned since is a column, you can do this:

 

Not assigned since = DATEDIFF([Created Date],TODAY(),DAY)

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Missing owners not assigned since X days

Hi @ymirza

 

You may create a measure as below:

Measure =
IF (
    MAX ( Table1[Owners] ) = "Owner not assigned",
    DATEDIFF ( MAX ( Table1[Created date] ), TODAY (), DAY )
)

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ymirza Regular Visitor
Regular Visitor

Re: Missing owners not assigned since X days

Hi @v-cherch-msft, i tried your solution it is giving some values but only returing value 1, instead of actual difference of days. Plus it is hiding all the other rows where owners are assigned.

 Powerbi error.jpg

Community Support Team
Community Support Team

Re: Missing owners not assigned since X days

Hi @ymirza

 

Remove .[Date] in your formula. Click the 'show items with no data' in the values filed.

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Missing owners not assigned since X days

Hi @ymirza

 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. If not, please share more details about your issue so that we could help further on it.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.