Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I also tried this but not ok...
Hi @Anonymous ,
Could you please provide more details about your Daily Issues table to help us clarify your scenario?
Like the columns fields, the relationship between Daily Issues table and Date table and your expected average values.
Or if possible, please share me with your pbix file after removing sensitive data.
Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
ot working....the result still shows a generic average and not per month as you see, and also not separated by year...I need to filter 2022 or 2021 to see the actual result, but anyway I need to see average per month
@Anonymous , try like
AverageX (values('Date Table'[Month Sort]), calculate(AVERAGE('Daily Issues'[LoadTime]),'Date Table'[Year]=MAX('Date Table'[Year])-1))
or
calculate(AverageX (values('Date Table'[Month Sort]), calculate(AVERAGE('Daily Issues'[LoadTime])),'Date Table'[Year]=MAX('Date Table'[Year])-1))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |