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] ) )

lewisbaybutt5DT's avatar
lewisbaybutt5DT
Regular Visitor
4 years ago

 Thank you so much for this Allison. This is perfect!

On another note. I have a 'duration' column in dataverse. Power Query Editor sees it as a number and I try to convert to duration to get it as minutes or to display as hours and minuted but it takes the minutes value and understands it as days. Any ideas?

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

lewisbaybutt5DT you may need to use math to convert it back to total minutes. I don't use dataverse often so not sure what format it pulls through as. If you can provide sample of the decimal and what duration it should be I can help with the power query M code for it.