Forum Discussion

AspiringAnalyst's avatar
AspiringAnalyst
Frequent Visitor
2 years ago
Solved

Calculate task forecasts with time intelligence based on summing a value

Hello all,   My business case is that I have a nursery.  I'm recording GDUs (growing degree units) each day and have a calculated column set up that if I populate my known GDU accumulated by day it...
"DAX help"
"Time Intelligence"
  • lbendlin's avatar
    lbendlin
    2 years ago

    Please provide sample data that fully covers your issue.
    Please show the expected outcome based on the sample data you provided.

  • lbendlin's avatar
    lbendlin
    2 years ago

    Here's the Ready Date as a calculated column in the checklist table

     

    Ready Dt = 
var a = filter('GDU tracking',[Date]>=[Planting Date])
var b = ADDCOLUMNS(a,"c",var d = [Date] return sumx(filter(a,[Date]<=d),[CalculatedGDUs]))
var c = filter(b,[c]<=[GDU required])
return maxx(topn(1,c,[Date],DESC),[Date])
lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

AspiringAnalyst's avatar
AspiringAnalyst
Frequent Visitor
2 years ago

The only thing different was that I had a few varieties that weren't yet planted.  I was just asking your opinion on how you'd handle that, but I just set a filter to not show things not yet planted.

Thank you for your help.