Forum Discussion

abujouz86's avatar
abujouz86
Icon for Helper II rankHelper II
5 years ago
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...
Need Help
  • abujouz86's avatar
    abujouz86
    5 years ago

    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) 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

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?

 

 

  • abujouz86's avatar
    abujouz86
    Icon for Helper II rankHelper II
    5 years ago

    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