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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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