Forum Discussion

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
6 years ago
Solved

Calculate log values for a column

Hi Guys,

I would like to generate log values for a column.

 

This Log values can either be a clculated measure or a calculated column.

 

I tried the functions LOG and LOG10. But they seem to accept only single values

 

Any ideas that could generate log on a column.

My expected data is shown below

 

BusMileageLog Mileage
A30.477
B20.301
C3.50.544
D2.890.460

 

Best Regards

Need Help

2 Replies

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Thejeswar ,

     

    You can use this for a calculated column:

    ColumnName = LOG10('Table'[Mileage])
    ColumnName = LOG('Table'[Mileage])
     
    For measures:
    log = LOG(SUM('Table'[Mileage]))
    log = LOG10(SUM('Table'[Mileage]))
     
    Ricardo