Forum Discussion
jaimeafanador
6 years agoRegular Visitor
R script to get historical data
Hi, Could be possible to use a R script to copy a meaure value to another table and get historical data?
3 Replies
- mahoneypatMicrosoft Employee
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
- jaimeafanadorRegular Visitor
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
- amitchandakSuper User
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/