Assigned date and Order date issue(Need Measure)

[NavaneethaRaju]

Hi Team,

I need a advice and need measure or calculated column to find the details.

Requirement- I have consigned(assigned) date on particular tagID, that tagID has been used after some days. I need calculate the duration. And some of the tags are consigned to me, but i'm not even used still this day. i want to know how many days that not used.

For Example:

TagID-10001 is consigned to me 25-6-2021, but i used that in 20-05-2022. i used after 330 days. i want the result as 330 days, like all the tag id's which are when its used after consigned date. 

TagID- 10002 was still not used upto currentdate, i want to calculate today as a last date and have to find how many days that was not used. as per my table data its not even used 360 days.

I want the measure or calculate column to find the difference how many days particular tag has used/not used

[v-yalanwu-msft · Accepted solution]

Hi， @NavaneethaRaju ；

You could create a measure .

Measure = IF( MAX('Table'[Order Date])=BLANK(),DATEDIFF(MIN('Table'[Consigned Date]),TODAY(),DAY),DATEDIFF(MIN('Table'[Consigned Date]),MAX('Table'[Order Date]),DAY))

The final show:

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

[amitchandak]

@NavaneethaRaju , Try a new measure line

minx(filter(allselected(Table), Table[Tag ID] = max(Table[Tag ID])), [Order Date]) - maxx(filter(allselected(Table), Table[Tag ID] = max(Table[Tag ID])), [consigned Date])