Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
NavaneethaRaju
Helper IV
Helper IV

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.

NavaneethaRaju_0-1655709966507.png

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

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1655970117800.png


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.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1655970117800.png


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
Super User
Super User

@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])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.