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

I have a measure set to "sum of number of plants" based off of my column of "number of rows" of that variety.  "Sum of number of plants" is set to "number of rows" * 20.  Categorized by crop in the legend.  I'm unable to set "Ready Date" to the x axis to show number of plants (workload) by day.  I have these dimensions set in the planted.pbix model you uploaded but the reply function isn't allowing me to upload it to show my example.  Not that I can figure out anyway.