Data Type Changes After Closing Power Query

[ojie]

Hi guys

I have a custom column as shown below in power query

But when I close and apply

It changes to the below on the Data tab of my report

How do I correct this behavior..

Thanks

[v-alq-msft · Accepted solution]

Hi, @ojie 

You may add a new step as below in Power Query to convert 'Duration' data type to 'Text' before applying changes to Power BI Desktop. The pbix file is attached in the end.

= Table.TransformColumns(#"Changed Type",{"Column",each Duration.ToText(_)})

Result:

 

Best Regards

Allan

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[PhilipTreacy]

@ojie 

You're welcome.

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[PhilipTreacy]

Hi @ojie 

Power Pivot doesn't have a Duration data type,so it converts your durations in PQ to decimal numbers where 1.0 represents 1 day.

Phil

[ojie]

Thank you @PhilipTreacy 

[ojie]

@PhilipTreacy  Can you help here? thanks