Forum Discussion
Convert Tableau expression to dax
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.
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/
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 .
Have you checked on the sample pbix. Filtering the visuals to a month should still return the rolling average correctly
danextian i checked the attached Power bi file in above article but i need Rooling average based on slicer selection, for example user select April 2024 in slicer then i need to display in Barchart to Dec 2023,Jan 2024 Feb 2024, March 2024, April 2024(That month).