I have Amount data based on Startdate date. How can I write the 12-month average?
i'm new, it is important to me that you are clear 🙏 thanks
Solved! Go to Solution.
Hello, I want the following rolling average 4 result. But since this measure was created with quick measure, I could only use it with hierarchy.
I want this measure to be used without a date hierarchy.
Share the download link of the PBI file.
thanks! that works.
Can we show the year 2022 when it is selected as a cumulative? I also want to show the last 6 months @Ashish_Mathur
You are welcome. In my measure, change the -11 to -5.
Your question is not clear. Please clarify.
I still do not understand your requirement. Show the expected result very clearly in an MS Excel file with formulas. I will try to convert those Excel formulas into DAX formulas.
Hi @sonya7 ,
You can refer the following links to get it:
Sales R12M = VAR NumOfMonths = 12 VAR LastCurrentDate = MAX ( 'Date'[Date] ) VAR Period = DATESINPERIOD ( 'Date'[Date], LastCurrentDate, - NumOfMonths, MONTH ) VAR Result = CALCULATE ( AVERAGEX ( VALUES ( 'Date'[Calendar Year Month] ), [Sales Amount] ), Period ) VAR FirstDateInPeriod = MINX ( Period, 'Date'[Date] ) VAR LastDateWithSales = MAX ( Sales[Order Date] ) RETURN IF ( FirstDateInPeriod <= LastDateWithSales, Result )
Hi, to the extent that I use it for averaging, I unfortunately get incorrect results. Could you change the dimension in the image to its non-hierarchy?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.