Forum Discussion
Assigned date and Order date issue(Need Measure)
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
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.
2 Replies
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])
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.
