Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
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.
Proud to be a Super User!
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
Proud to be a Super User!