Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, could anyone help me with this?
Finally, I've been able to achieve this:
But is it possible to get something like this, years separated? I made every effort ....
Solved! Go to Solution.
@Anonymous , Try to avoid date hierarchy and create column for month and year and use that.
Try a meausre like
calculate(AverageX(values(Calendar[Ano]), [Total]), filter(allselected(Calendar), Calendar[Year] = max(Calendar[Year])))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |