Forum Discussion
Calculated Measures vs Calculated Columns
Hello Dazzling DAX users, I have a conundrum. I can't make the following visuals using calculated measures. - Line Chart, Bar Chart, etc. I am limited to a table. Here are my calculated measu...
Hi FreemanZ - thank you for the nudge.
I thought that by pulling in Total Tutoring Hours that i summed.
But i have to sum in hour in the calculated measure of Tutoring Hours in HH:MM.
Am i understanding you correctly?
Total Tutoring Hours = SUM(Separate[Tutoring Time (30 Minutes each session)])
Tutoring in HH:MM =
VAR _Min = [Total Tutoring Hours]*30
VAR HourNo = INT(_Min/60)
VAR minuteNo = MOD(_Min, 60)
Return FORMAT(HourNo, "#00") & ":" & FORMAT(minuteNo, "#00")