Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to derive the DAX = "Total Latest Forecast" BUT i cannot get the total to sum to 1003 + 3002 +2004 =6009 .... Instead I get 2004 . Can you help ?
Solved! Go to Solution.
Well, there is another solution in this case:
Total Latest Forecast =
SUMX (
SUMMARIZE (
Fact_Forecast,
Fact_Forecast[client],
"Date", MAX ( Fact_Forecast[fcst cutoffdate] ),
"Total Forecast", MAX ( Fact_Forecast[Total Forecast] )
),
[Total Forecast]
)
You may redownload the sample file if you want, it is updated.
excellent.. thank you.. i see by summaring, you are returing only forecast relevant to the max date.. then sum that expression..
Exactly, simple and straightforward.
You're alomst there, just need to adjust your filter a little.
Total Latest Forecast =
CALCULATE (
SUM ( [Total Forecast] ),
FILTER ( ALLEXCEPT ( Fact_Forecast, Fact_Forecast[client] ),
[fcst cutoffdate] = MAX ( [fcst cutoffdate] )
)
)
You may check this sample file
i notice your total = 2004 instead of 6009.... is there a way where it sums up to 6009
Well, there is another solution in this case:
Total Latest Forecast =
SUMX (
SUMMARIZE (
Fact_Forecast,
Fact_Forecast[client],
"Date", MAX ( Fact_Forecast[fcst cutoffdate] ),
"Total Forecast", MAX ( Fact_Forecast[Total Forecast] )
),
[Total Forecast]
)
You may redownload the sample file if you want, it is updated.
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
31 | |
19 | |
18 |