Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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.
@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])
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |