Forum Discussion
Solved
Etherscan api
Anyone here with experience using the Etherscan api? I'm having some challenge with transaction values. The api is dumping decimal numbers into pbi as integers and I'm not sure how to either corr...
Great, that got me thinking on the right path, thank you! What I did was:
1- extract the first four digits from "value" column
2- count the characters in "value" column
3-divide first four digit column with a calculated column using IFs based on the character count to divide by 1xxxx (x being 0)
abujouz86 value column in Power BI is shown in Power Query? Not sure why .0205 will come as such a huge number. what value do you see before changing the data type step?
Yes, shown in power query. Changing to decimal number data type didn't work and is not correct
value
| 2.05E+16 |
| 1E+18 |
change decimal from auto to 0
value
| 20500000000000000 |
| 1000000000000000000 |