Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

total value in table

I've a simple table with whole number values in the last column (no calculation). I would just like to total these values. But I'm ending up with just the value from one row.    I have the fo...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Luckily I like skiing in Austria and know a bit of German 😉

    Can you share your original dataset that is below this visual? There seems to be something wrong going on there. For example, is "Soll Stunden pro Woche" in the same or related table as your "Beginn der Woche" and "Ende der Woche" columns? If not, that would explain why this is happening as it is just returning the total sum of Soll Stunden of that table, unfiltered by the context of the table visual.

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

According to your description, i am confused about how you calculate this column [Hours per week].

And if you want to calculate time gap, please try to use DATEDIFF function.

I create a simple table to test:

Then, create a calculated column:

Hours per week = DATEDIFF('Table'[Start Time],'Table'[End Time],HOUR)

And it shows the correct total:

Hope this helps.

 

Best Regards,

Giotto Zhi