Forum Discussion

npombo's avatar
npombo
Icon for Helper I rankHelper I
4 years ago

Calculating Difference in Hours Based on Timestamps Residing in the Same Column

Hello,   I am hoping to enlist some help in writing this particular calculated column. My data table is currently organized like this:   Item ID | Type of Transaction | Date 1           | Buy   ...
Need Help
npombo's avatar
npombo
Icon for Helper I rankHelper I
4 years ago

Hi rsbn,

 

Thank you for your response. Unfortunately, the data I am working with is derived from a live dataset and I therefore don't have the ability to use Power Query. This is what I see when I go to transform data:

The solution would have to come in the form of calculated measures, calculated columns, and calculated tables. Please let me know if you have any other ideas!

 

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
4 years ago

npombo ,

Understand the constraints.  Unfortunately, don't have the time now.

Suggest you re-post and ensure you add in this new fact.  You should get some help tonight, but if not, I can have another go at it in the morning.

Regards,