Forum Discussion
Related calculated column
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] ) )
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
Community Champion
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.
Sorry for the slow reply AllisonKennedy . Here is a couple of screenshots. It is pulling through 1 hour/60 minutes as 60 days.
- AllisonKennedy
lewisbaybutt5DT Maybe transform data type to Text, and Extract > Text Before Delimiter > :
Then Transform Data Type to Decimal number to arrive at total hours?