Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have created a matrix like the one below using a calculated field that shows displays Sales numbers across 2 levels, as a % (percentage) of the previous level, Level 1 and 2 being STATE and CITY.
I would like to add another column towards the end that displays the average of this % metric, for the last 3 months of my dataset. Currently, I am working with data till January 2018. However, as I keep adding new data every month, this will change.
Request your help with a DAX formula to implement this.
Below are the formulae I have used for the calculated field-
Hi @may17,
Just see from the formula, it should work. I would suggest you create an independent date table and establish relationships with other tables. Can you share a sample?
Best Regards,
Dale
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |