Hi there, I am trying to calculate the half an hour sum of the column named 'Result' using following formula30min sum = SUMX(VALUES(Times[Half Hour]),'Key Measures'[Result]) But it did not produce the desired result as shown in the picture: Link of the file can be found here https://1drv.ms/u/s!AucycxZHFe9TjS6G96JVtgslQLBX?e=60MvUf. Could anyone guide me where I made the mistake

Dunner2020 I think this is what you are looking for: 30min sum = SUMX(VALUES(Times[Half Hour]),[Result]) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation! ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Hi parry2k , Thanks for your reply. I tried with 30min sum = SUMX(VALUES(Times[Half Hour]),[Result])But it did not produce the desired result. It did not sum up the value based on half an hour. Here is the result:

Can you give me a couple of examples of your desired results?

Thanks Anonymous , for your reply. I want to sum up the result value if it happens in the same half an hour value. For example, if you look at the picuture, among top 5 rows, 4 of them happened in the same half hour time (i.e. 11.30 pm) so I want to add result column of those 4 rows. Does that make sense?

Please try these expressions instead. New Result = CALCULATE ( SUMX ( 'Customer Information', 'Customer Information'[NumberOfConsumers] * 'Customer Information'[Time Spent] ), 'Customer Information'[Time Spent] > 1, 'Customer Information'[NumberOfConsumers] > 1 ) Sum 30 = SUMX ( SUMMARIZE ( 'Customer Information', Dates[Date], Times[Half Hour] ), [New Result] ) If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.Regards,Pat

half an hour sum | Microsoft Fabric Community

13 Replies

parry2k
Super User
6 years ago
Dunner2020 I think this is what you are looking for:

30min sum = SUMX(VALUES(Times[Half Hour]),[Result])

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- Dunner2020
  Post Prodigy
  6 years ago
  Hi parry2k , Thanks for your reply.
  I tried with
  30min sum = SUMX(VALUES(Times[Half Hour]),[Result])
  But it did not produce the desired result. It did not sum up the value based on half an hour.
  Here is the result:
  - Anonymous
    Not applicable
    6 years ago
    Can you give me a couple of examples of your desired results?
v-juanli-msft
Community Support
6 years ago
Hi Dunner2020

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie
- Dunner2020
  Post Prodigy
  6 years ago
  Hi v-juanli-msft (Maggie),
  
  No, it did not solve the issue.
v-juanli-msft
Community Support
6 years ago
Hi Dunner2020

You could relate [half hour] from "Times" table into your main table to create a [new half hour] column, then use this column in your measure instead of "Times'[Half Hour].

Best Regards

Maggie

Forum Discussion

half an hour sum

13 Replies

Related content

Hour Calculation

Sum hours

Sum Hours and Minutes

Sum hours With Combined Period

Sum hours