Forum Discussion

lewisbaybutt5DT's avatar
lewisbaybutt5DT
Regular Visitor
4 years ago
Solved

Related calculated column

I have three tables in dataverse. A case table, session bookings table and a session types table. My session bookings table has lookups to both the 'case' and 'session type'. My session types table h...
General Comment
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    lewisbaybutt5DT  Create new measures and put them in a visual with CaseTable[CaseType]: 

     

    Total Cost = SUMX(SessionBookings, RELATED( SessionTypes[SessionLength] ) * RELATED( SessionTypes[SessionLength] ) )

     

    Total Duration = SUMX(SessionBookings, RELATED( SessionTypes[SessionLength] ) )

AllisonKennedy's avatar
AllisonKennedy
Community Champion
4 years ago

lewisbaybutt5DT  Maybe transform data type to Text, and Extract > Text Before Delimiter > :

 

Then Transform Data Type to Decimal number to arrive at total hours?

lewisbaybutt5DT's avatar
lewisbaybutt5DT
Regular Visitor
4 years ago

Thanks AllisonKennedy  - This is a really odd one. I converted to text and then it just displayed as '60' so I couldn't extract. Anyway, I've ended up converting to decimal number and then I used the divide function to divide whatever the value is by 60 to get the hours. It was showing the minutes as 'days', but as a decimal number it doesn't matter as I knew it was minutes so I've gone with that! Thanks for your help 🙂