R script to get historical data

[jaimeafanador]

Hi, Could be possible to use a R script to copy a meaure value to another table and get historical data?

[amitchandak]

@jaimeafanador , not sure about R, but see if this can help

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[mahoneypat]

You can do a lot with R scripts but you shouldn't need one to analyze historical data.  Can you explain more about your use case?

Regards,

Pat

[jaimeafanador]

Hi, I have financial information across all sharepoint list pwa collection.

I need to create a KPI indicator to grahp financial historical data. 

right now i have a meause value but just get the actual value, i need to send the old value to another table and store that data to allow me to grahp historical data and allow me use KPI indicators.

thakns