Forum Discussion
Calculate task forecasts with time intelligence based on summing a value
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.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])
should be possible. What's on the Y axis?
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.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Hi lbendlin, I have uploaded my pbix example to a dropbox. I've tried to use ChatGPT to help convert the results to a calculated column though the results don't match up with your measure outputs. Those are correct.
My end goal is to summarize number of plants by ready date and in what field. Fields aren't in my example file though and that's not a concern really as that's already available in my working file and is easily sliced to summarize a given date's workload.
I can't add the ready date measure to a slicer, and I'm struggling to add the ready date measure to an x axis. I'd like to use a clustered column chart to show workload over time, and for daily task setting a table that summarizes number of plants by date and their fields. Variety isn't that important for that table, that's just the level of granularity that the GDU is set to.
Is a calculated column possible?
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])