DAX formula or any other alternate

[AbdulRahman86]

Hello Team,

I really required your kind help on below request. I just attached screeshot . need expected results as in the form of  table in Report view of  power bi desktop. 

[AbdulRahman86]

Hello All,

Attached sample data with expected results. 

https://drive.google.com/file/d/1i_IC6XwMMdTtvq5SjLeaR38ny9eIJifJ/view?usp=drive_link 

[AbdulRahman86]

Hello All, 
I m trying my best to share sample data here , i have data like first table,  need out put as shown in output table . 

BU ID	Status 1	Status 2	Start Time		Output for for Each BU ID
1	A	B	27-06-2025 10:54				Difference in mins
1	A	B	27-06-2025 11:54		min of A and B	27-06-2025 10:54
1	A	B	27-06-2025 13:54		Min of E and F	27-06-2025 11:54	0.041671181
1	E	F	27-06-2025 11:54
1	E	F	27-06-2025 12:54		Min of E and F	27-06-2025 11:54
1	C	D	28-06-2025 11:54		Max of E and F	27-06-2025 12:54	0.041662153
2	A	B	27-06-2025 19:54
2	A	B	27-06-2025 11:54		Max of E and F	27-06-2025 12:54
2	C	D	28-06-2025 11:54		min of C and	28-06-2025 11:54	0.958333333
2	C	D	27-06-2025 22:06
2	A	B	27-06-2025 11:54

[v-kpoloju-msft]

Hi @AbdulRahman86,

Thank you for reaching out to the Microsoft fabric community forum.  I reproduced the scenario again, and it worked on my end. I used my sample data and successfully implemented it. Used line chart.

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[v-kpoloju-msft]

Hi @AbdulRahman86,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @AbdulRahman86,

Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

Thank you.

[v-kpoloju-msft]

Hi @AbdulRahman86,

Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[v-kpoloju-msft]

Hi @AbdulRahman86,

Thank you for reaching out to the Microsoft fabric community forum. Also thanks to @Ashish_Mathur, @danextian, @Greg_Deckler, I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.

After loading the sample data into Power BI using the Text/CSV import option, open the Power Query Editor by selecting Transform Data. Ensure that the Start Time column is correctly recognized as a Date/Time type. Next, perform a grouping operation by selecting the BU ID, Status 1, and Status 2 columns. In the Group By dialog, configure it to compute two new columns: one that returns the earliest (Min) Start Time, and another that returns the latest (Max) Start Time within each group.

Once the data is grouped, create a new column to calculate the duration between the earliest and latest Start Time values. This can be done by adding a custom column with the formula:

Duration.Hours([Max Start Time] - [Min Start Time])

Rename Min Start Time to Start Time, Max Start Time to End Time, and Custom to Difference in Hours. Once the transformations are complete, click Close & Apply to load the grouped and calculated results into your Power BI model. You can now create a table visual with BU ID, Status 1, Status 2, Start Time, End Time, and Difference in Hours to match the expected output.

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[danextian]

Hi @AbdulRahman86 

You didnt tell us how to arrive to those results? What is the logic? How to calculate them? Also, what are the highlights for?

[AbdulRahman86]

Hi , 

Here is problem statement, we have different set of BU ids, every BU ids contains status1 and status2, with duplicate status , so I want to find out max date and time stamp of same this combination "Status A and Status B" then for same Status A and Status B need to find out Min date and time stamp  , once we got max and min for these status , need to find out difference in hours. 

That's it.

I hope it s clear. 

thanks for your time. 

[AbdulRahman86]

Hello Greg,

Thanks for guiding, 

As you requested, I have uploaded sample data in the form of table 

and shown expected results also.

Could you please help me. 

[AbdulRahman86]

Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11
BU ID	Status 1	Status 2	Start Time	RAWDATA
1	A	B	27-06-2025 10:54
1	C	D	27-06-2025 11:54
1	A	B	27-06-2025 11:54
1	E	F	27-06-2025 11:54
1	C	D	27-06-2025 12:54
1	C	D	27-06-2025 11:54
1	A	B	27-06-2025 13:54
2	A	B	27-06-2025 19:54
2	C	D	27-06-2025 23:54
2	A	B	27-06-2025 11:54
2	C	D	28-06-2025 11:54
2	C	D	27-06-2025 22:06
2	A	B	27-06-2025 11:54
Below is expected Results
BU ID	Status 1	Staus 2	Start Time	End Time	Difference in hours	Status 1	Staus 2	Start Time	End Time	Difference in hours
1	A	B	27-06-2025 10:54	27-06-2025 13:54	3.00	C	D	27-06-2025 11:54	27-06-2025 12:54	1.00
2	A	B	27-06-2025 19:54	27-06-2025 22:06	2.20	C	D	27-06-2025 23:54	28-06-2025 11:54	12.00

[Ashish_Mathur]

Hi,

If you want to do it with DAX measures, then you may not get your desired structure but you will get the correct result.  To a table visual, drag BU ID, Status 1 and Status 2 to the row labels.  Write these measures

Min = min(Data[Start time])

Max = max(Data[Start time])

Diff = [max]-[min]

Hope this helps.

[Greg_Deckler]

@AbdulRahman86 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.