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])
AspiringAnalyst's avatar
AspiringAnalyst
Frequent Visitor
2 years ago

Wow thank you!

I've transferred the measures into my working model and I see that in instances of varieties not yet populated with a planting date, it is summing from the beginning of the CalculatedGDUs column.  What is the best way to not assign Ready Dates to those items?  Would it be in the DAX expression itself or through a Filter on the page/visuals removing null values for planting 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.