Forum Discussion

jjwerkman's avatar
jjwerkman
Regular Visitor
5 years ago

Quick Measure (time table) stops grouping customer

Need a little bit help.  I count (sum) different (this moment 3) time tables. The first 2 tables are working as intended. The table shows the customer (once) with the calculated time. When I add the...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

jjwerkman , you can take some sample data and copy-paste here. Both input and output expected.

 

I think these blogs can also help you


https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

jjwerkman's avatar
jjwerkman
Regular Visitor
5 years ago

It's not that easy. Still looking for a way to do so. There's no button to anonimise all data. Think I need to built a complete new pbix file with manual created tables and put data in it.