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...
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.
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.