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 suppor...
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.
- For your information, the RAW data was already duration and formatted as General.
