Log transformation of variables

[farah2016]

Hey guys I am trying to use log to transform one of my variables. I have done this in R previoulsy:

m5$logv1 <- log(m5$v1)

Any suggestions re: how I can accomplish this ? I thought I could do it directly using R script through the Query Editor but It doesn't recognize m5 as my object name. 

Caution- very new to power bi.

Thanks!

[Greg_Deckler · Accepted solution]

Not sure what you m5 is, is that a data frame or something? In any event, in R Script, usually "dataset" holds your data frame. Also, not sure why you would need to use R to transform your data, M has Number.Log and Number.Log10 functions and DAX has LOG and LOG10 functions.

[Greg_Deckler · Accepted solution]

Not sure what you m5 is, is that a data frame or something? In any event, in R Script, usually "dataset" holds your data frame. Also, not sure why you would need to use R to transform your data, M has Number.Log and Number.Log10 functions and DAX has LOG and LOG10 functions.

[farah2016 · Accepted solution]

m5 is the dataset. And just figured out how I can log each column through the Scientific transformation under Add Column ribbon. 

Thanks!

[v-qiuyu-msft]

Hi @farah2016,

According to your description, it seems that you find the solution, right? If that is a case, would you please mark a helpful reply as an answer to close the thread? If not, please feel free to let me know.

Best Regards,
Qiuyun Yu