Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need help on the table that I have. I want to get the 3 month (Aug, Jul and Jun) average per registry of the average table.
Can you help me in providing the DAX measurement or if i need a new table?
Hi,
Share the link from where i can download your file. Also, please show the expected result.
Hi,
Sorry, I cannot share the pbix as there are a lot of files in it.
But, for the result, what i would want is to show the average of the last 3 months per aircraft registry.
Hi,
Share a dummy dataset.
If you want to calculate the moving 3 months average,you can write a measure like below:
Moving 3 months avg= CALCULATE ( AVERAGE ( Table[DSR] ), ALLEXCEPT ( Table, Table[Registry] ), FILTER ( ALL ( Table ), Table[MonthYearNumber] ) > ( MAX ( Table[MonthYearNumber] ) - 3 ) && Table[MonthYearNumber] <= MAX ( Table[MonthYearNumber] ) )
Regards,
Hi,
From the formula you have provided, it gives me an error "A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
Also, can i place this in a table?
Thank you
Sorry, there's an incorrect bracket.
Updated:
Moving 3 months avg= CALCULATE ( AVERAGE ( Table[DSR] ), ALLEXCEPT ( Table, Table[Registry] ), FILTER ( ALL ( Table ), Table[MonthYearNumber] > ( MAX ( Table[MonthYearNumber] ) - 3 ) && Table[MonthYearNumber] <= MAX ( Table[MonthYearNumber] )) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |