Mann Kandell Analysis within power bi using r script

[Anonymous]

Hi Expert

i want to work out from my small data set the TAU and P Values using Mann Kendall in R Script in Power Query (after i have cleaned up the data) and show if my data has a signifcant trend up or down wards in a table...

so if the mann kendall value is <=0.05 and the TAU > 0 then upward arrow and

if the mann kendall value is <=0.05 and the TAU < 0 then downward arrow

Happy to upload a file to one drive if required, unless you can show me how to upload a PBIX file on this site...

[v-xicai]

Hi @Anonymous ,

You can upload a file to one drive following steps below,  and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy

[Anonymous]

HI Amy

See link for drop box. https://www.dropbox.com/s/y30he41wooufp9z/MK_Missing_Data_TIme_Series.pbix?dl=0

[Anonymous]

Thanks Amy for the feedback no sensitive data included. Give me 20 minutes,