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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Danyal
Regular Visitor

Row based time calculation

Good Day everyone

 

I need a measure where i can show hours/mins 1 customer took from one to another move?

 

 

Danyal_0-1690371435122.png 

Danyal_1-1690371455654.png

 

data_source_veiw


P_ID      Customer            Move_Name    Move_ID  change_time

9250botanaNew 37/24/2023 6:25
9250botanaHold57/24/2023 6:29
9118GysaNew 37/23/2023 13:08
9118GysaApproved117/23/2023 13:08
9118GysaWon27/23/2023 13:11
9118GysaBusiness157/24/2023 7:03
9275hanaNew 137/24/2023 10:45
9275hanaHold57/24/2023 10:46
9157hhmaakka2New 37/20/2023 6:50
9157hhmaakka2 Approved117/20/2023 9:25
9157hhmaakka2 Won27/20/2023 10:21
6748iflashNew 37/24/2023 13:27
6748iflashHold57/24/2023 13:28
9116coffeeNew 37/23/2023 8:48
9116coffeeQualified107/23/2023 8:48
9116coffeeWon27/23/2023 8:24
9116coffeeBusiness157/23/2023 8:23
9146w2fgiiNew 37/20/2023 7:17
9146w2fgiiHold57/20/2023 7:23
9146w2fgiiQualified107/20/2023 7:33
9146w2fgii Approved117/20/2023 7:35
2 REPLIES 2
Danyal
Regular Visitor

HI @SamInogic ,

 

Thank you so much for helping out.

 

the provided measure seems fine but i doubt one thing, lets say one Move has 3 or more ids as one move will go under sevaral moves, so the goal is to calculate hours or minuts that a customer has spent in each move or from one to another move.

so the ultimate result would be i will create 2 slicers to select desied moves and it will show the hours or mintus that customer and move has taken.

 

thanks again for your input.

😊

SamInogic
Super User
Super User

Hi @Danyal ,

As per our understanding, you want to calculate the date difference between dates of “change_time” column as mentioned in the “data_source_veiw” table.

So, you can try to create a measure with below DAX expression,

diff =

    var _min=CALCULATE(MIN(data_source_veiw[change_time]),ALLEXCEPT('data_source_veiw',data_source_veiw[P_ID]))

    var _max=CALCULATE(MAX(data_source_veiw[change_time]),ALLEXCEPT('data_source_veiw',data_source_veiw[P_ID]))

return

    DATEDIFF(_min,_max,MINUTE)

 

Please refer to the below screenshot for the same,

SamInogic_0-1690875061365.png

 

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.