Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
Ah nevermind, i figured it out! Thanks anyway - really appreciate your help!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |