Multiple results in one formula

[Kolk1979]

Hi Everyone,

I created 3 new columns with the following formula's:

Raw_Daytime = IF(RELATED(TimeRegistrationReasons[reason])="Support - Daytime (100%)"; [timeSpent_inSeconds] ; IncidentTimeRegistrations[Time])

Daytime = FORMAT((IncidentTimeRegistrations[Raw_Daytime]/3600)/24; "HH:mm:ss")

Daytime_Total = SUM(IncidentTimeRegistrations[Daytime])

The last rule is a measurement.

Basically i filter the raw_daytime (which is text), convert it to hours and minutes and summarize it all.

I have it working with 3 formula's and 3 columns but i want to have it in 1 column if possible.

Thanks in advance,

[v-chuncz-msft · Accepted solution]

@Kolk1979,

You may just use <expression> in SUMX.