Forum Discussion
Power pivot cannot summarize Duration
Hi guys,
I am working on an power pivot where i am trying to summarize Duration from Power Query. However, there were error message "we can't summarize this field with sum because it's not supported calculation for date data types". I have define (change type) the column for the data with Duration, however Power Pivot still recognize it in Date data. Please help. Thanks
4 Replies
Such error usually if you don't define data type in Power Query (any), loading to data model it considered as text. If data type is Duration it's considered in data model as Decimal number. Sample:
Power Query:
data model:
[Custom] here is [End] - [Start]
- Hi Sergei Baklan. Thank you for you reply.
I actually have already defined the column to "Duration" in Power Query. But still the loaded into data model, the Power Pivot still recognize it as "Date" data.Please try to open attached (that's sample from the previous post) if it works in your environment correctly.
