Forum Discussion

Helper III

3 years ago

Solved

Calculate Hour Type Column Difference

Hi everyone, I text you because I'm trying to calculate the difference between the hour values of the same column. The objective is to find the sum of time for every value of "Defensive Five" col...

DATEDIFF

LOOKUPVALUE

tamerj1
3 years ago
Hi sfernamer
Here is a sample file containing my two previously proposed solutions. You are right about the 2nd solution, there was sime mistakes. Not sure if either what you're looking for.

Community 488.pbix56 KB

sfernamer

Helper III

3 years ago

I would like to add a sample of the dataset with 2 games and the columns related available to create the logic, to try to help. The Google Drive link to access to the Excel file: https://drive.google.com/drive/folders/1SlzwO6bgBBgrftwrVPGRVBE9KkIy_YqJ?usp=share_link

Thank you in advance tamerj1 / FreemanZ

Forum Discussion

Calculate Hour Type Column Difference

Related content

TMDL - calculated column

How to add two different calculated columns of two different table

1. How to add two different calculated columns of two different table

Dynamic Calculation Different Period

Different Calculations