Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Custom rolling average on time series

Hello, I am looking to write a simple script to create a column for a custom rolling average on time series shorter than a day.  Ideally I want to be able to perform a 10 min, 20 min, or a 40 min ti...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank you both.  In the end I processed the original CSV file with Pandas and exported it as a new CSV file that I could then import into PowerBI.  Sorry DAX is very clunky and doesn't compare to Pandas but PowerBI is nice for the aggregations and shared displays/dashboards on the cloud.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Datetimes are just decimal numbers with the integer portion as the # of days since 12/30/1899 and the decimal portion is the fraction of a day 1/24/60/60 for example.