Changing pennies into pounds

[adrianm2018]

Hi, 

I'm importing data that is measured in pennies, but I want to visualise and report on it in pounds. I'm really new to PowerBI so any help would be much appreciated. 

I'm sure it should be a 10 sec job for someone, but I literally have no clue where to start. 

Many thanks,

Adrian 

[v-yulgu-msft · Accepted solution]

Hi @adrianm2018,

You should first convert the value calculated from pennies to pounds, then, change the currency symbol.

 New a column with DAX:

Pounds = YourTableName[ValueColumn]/100

Best regards,

Yuliana Gu

[adrianm2018]

Thanks for the response @v-yulgu-msft

I created the new column in my table and the DAX formula works perfect. However, when I go back to my graphs I can't change the figures to return data based on the newly created 'Pound' value as I can't find my newly created value within the Currency drop down menu. Any thoughts on how I could do that?

Many thanks,

Adrian 

[adrianm2018]

Ah nevermind, i figured it out! Thanks anyway - really appreciate your help!