Forum Discussion

adamsli's avatar
adamsli
Helper I
5 years ago
Solved

Sum up connection time

Hi, How to aggregate connection_time? I want to sum up the time of connection to every month. Do I need create a new measure? If so, how to write it down into DAX formula? Styczeń means Janu...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi adamsli ,

     

    We have checked your file. The issue is the Auto Date function.

    You can close the Auto Date/Time function to solve this issue.

     

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi adamsli ,

 

Sorry for that we cannot download your pbix file.

When we click the download, it will jump to a new web page instead of downloading it.

 

 

 

Does your table structure like ours? And our subtraction’s type is Time.

 

 

 

If there is a gap between your data format and ours, you can paste the data in the reply, or you can tell me how to use the link you shared before.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

adamsli's avatar
adamsli
Helper I
5 years ago

Hi,

my subtraction in my case connection_time has format hour. In Power Query when I want to change to Duration type I'm receiving error:

New link to my report: https://www.transfernow.net/yPpV9e112020