Convert date to whole number

[Xilitor01]

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:

[selimovd]

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.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Xilitor01]

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.

[v-kelly-msft · Accepted 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!

[Xilitor01]

Thank you - it worked 🙂