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.
Hello,
am looking to fill in future null values with last 3 months averages using DAX measure.
Tried the power query solution but it appears complicated to apply. Please see below data sample screenshot for illustration.
NULLs are captured for June data onward:
Thanks,
M
Hi @MMB920 I understand that you want to see rolling average. If yes, then please create two measure and in Date table create Year month column like
1. Simple sum, M_supp_hrs = suM(Sheet14[support_hrs])
2.
Proud to be a Super User!
Hi @MMB920 please provide sample data with expected output for example
Proud to be a Super User!
Hello,
Here is a data sample (below) of what am trying to accomplish in PBI DAX (Column 4).
Team | Month | support_hrs | Forecasted (support_hrs) |
TEAM A | 1/1/2022 | 6.17 | Actual |
TEAM A | 2/1/2022 | 35.65 | Actual |
TEAM A | 3/1/2022 | 26.2 | Actual |
TEAM A | 4/1/2022 | 12.05 | Actual |
TEAM A | 5/1/2022 | 32.22 | Actual |
TEAM A | 6/1/2022 | 78.57 | Actual |
TEAM A | 7/1/2022 | 30.75 | Actual |
TEAM A | 8/1/2022 | 63.81 | Actual |
TEAM A | 9/1/2022 | 8.63 | Actual |
TEAM A | 10/1/2022 | 44.14 | Actual |
TEAM A | 11/1/2022 | 72.14 | Actual |
TEAM A | 12/1/2022 | 42.43 | Actual |
TEAM A | 1/1/2023 | 28.66 | Actual |
TEAM A | 2/1/2023 | 37.55 | Actual |
TEAM A | 3/1/2023 | 51.69 | Actual |
TEAM A | 4/1/2023 | 59.22 | Actual |
TEAM A | 5/1/2023 | 36.59 | Actual |
TEAM A | 6/1/2023 | 20.25 | Actual |
TEAM A | 7/1/2023 | 0 | = Ave of(June, May, Apr) |
TEAM A | 8/1/2023 | 0 | = Ave of (Jul,Jun,May) |
TEAM A | 9/1/2023 | 0 | = Ave of (Aug, Jul,Jun) |
TEAM A | 10/1/2023 | 0 | = Ave of (Spe, Aug, Jul) |
TEAM A | 11/1/2023 | 0 | = Ave of (Oct, Sep, Aug) |
TEAM A | 12/1/2023 | 0 | = Ave of (Nov, Oct, Sep) |
Please let me know if you need other details.
Thanks,
MMB
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 |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
75 | |
51 | |
46 | |
16 | |
12 |