Forum Discussion
Convert Tableau expression to dax
Hi Team i need convert below tableau expression to dax, Basically this will give rolling average based on month selected in slicer so can you please help me to fix this.
WINDOW_AVG([Forecast MAPEQ REQ Selected Period ACC_Max_restriction],-11,0)
Hi danextian , i tried this already but my requirement is I have a slicer when user select an month bar chart will show Rolling average for until that month .
I thought you wanted just the rolling average but show the past x months as well. Slicer selection from a related or the same table will filter the rows to just what are selected. You will need to use a disconnected table for that. Please see attached sample pbix.
5 Replies
Hi Anonymous
You will need something like below:
CALCULATE ( AVERAGEX ( ALL ( 'Calendar'[Year], 'Calendar'[Month] ), [Balance] ), DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), - 3, MONTH )Please refer to a similar post - https://community.fabric.microsoft.com/t5/Desktop/Measure-Rolling-average/m-p/4049892#M1285912
This is discussed in detail at - https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/