Forum Discussion
Rolling average based on a dynamic sequence measure
Hi, I am trying to calculate a dynamic 2-sequence rolling average based on the calulated table below. First I created a dynamic sequence number that updates with slicers. The column is called...
amitchandak
Super User
Super UserSveina , Consider the new window function
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
Rolling Days Formula: https://youtu.be/cJVj5nhkKBw
Hi amitchandak,
Thanks for your suggestion.
Unfortunately I do not have the new WINDOW function yet, and same with ORDERBY. I guess they are not available in Scandinavia.