Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to extract the price from Excel into PowerBI but it keeps reading the data as a date. Can anyone help me with getting PowerBI to read the prices correctly? Thank you 🙂
Excel-data:
PowerBI reads it as:
But I want it to be like:
Solved! Go to Solution.
Hi @Xilitor01 ,
Using below M codes:
= Table.AddColumn(#"Promoted Headers", "Custom", each 24*Number.From([Price]))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hey @Xilitor01 ,
in Power Query add a step where you replace ":00:00" with ".00".
Afterwards transform to a decimal number, that should do it.
Thank you for your response.
I do the following steps:
But as you can see the numbers are incorrect.
Let me know if I do something incorrectly.
Hi @Xilitor01 ,
Using below M codes:
= Table.AddColumn(#"Promoted Headers", "Custom", each 24*Number.From([Price]))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Thank you - it worked 🙂
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |