Get Duration from Max DateTime and Min DateTime from a single column

[Anonymous]

I would like to get duration from a single column that have time stamp and I would like my duration(mesure) to return value group by column(s) name. In this example I am using Country (column) but that might be change. Please see my sample data

My Sample Data
Country	Timelog
India	09-May-2019 7:00
Japan	09-May-2019 19:50
USA	09-May-2019 20:00
India	10-May-2019 6:00

Desired Result: Grouping by any column, for now I am using Country but Column should be dynamic

Country	Duration
India	23 hours
Japan	0 Hours

Thanks,

Kulchandra

[Mariusz · Accepted solution]

Hi @Anonymous 

You can create measure like below.

Measure = DATEDIFF( MIN( 'Table'[Timelog] ), MAX( 'Table'[Timelog] ), HOUR )

This will give you the result.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.