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 in this really bad.
I am trying to obtain Current MTD Average & Previous MTD Average of selected dates through a filter.
I have used the Following measure for the current MTD average:
Hi @Hashmi
please try
Avg_DAILYBASE_LM =
AVERAGEX (
VALUES ( 'DB'[DATA_DATE] ),
CALCULATE (
AVERAGE ( 'DB'[DAILY_ACTIVE] ),
DATEADD ( 'DB'[DATA_DATE], -1, MONTH )
)
)
@Mahesh0016 Hi thankyou for your reply, but unfortunately the issue still presists. after doing the recommended change the averages in days values have further become incorrect.
Plus the total average of the selected date range is of CM.
@Hashmi I hope this helps you!!THANK YOU!!
var MX_Month = MAX('DB'[DATA_DATE])-1
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |