Forum Discussion
Moving Average
Hello Friends, I am working on a dataset for my project and need to create a moving average. Below is the sample dataset that i am using. Can you suggest me the DAX command for the same. Company...
amitchandak
Super User
Super UserAbhijith_KG , based on what I got
New column = averageX(filter(Table, [Date] = earlier([Date])),[Close])
or
New measure = averageX(filter(allselected(Table), Table[Date] = max(Table[Date])),[Close])