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 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).
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.