Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |