Forum Discussion

dpla0001's avatar
dpla0001
New Member
3 years ago

How to connect table to change data in R in Power Query

Hello,

I need to edit some data using R in Power Query. I have already uploaded the dataset which is called 'Product Inventory'. I am using the code below to try and edit the data, but keep getting errors.

 

[Product Inventory] = dataset

[Product Inventory]$service <- factor([Product Inventory]$service, levels=c(2, 8, 9, 12),

                      labels=c("4", "16", "18", "24")

 

I think the issue is connecting the dataset, but haven't been able to fix it.

Need Help

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    What error are you seeing? Please share sample input data and desired output. It may not be necessary to use R, but the community can provide example M and/or R code either way.

     

    Pat