Trend from measure

[sw123]

Hi!

I would like to calculate a trend from a measure like this:

Trend Tons/Vehicles = calculate(sum(MaxCapacity[Tons/Vehicles]), DATESINPERIOD(DateTable[Date], LASTDATE(F_Sales_[Delivery date]), -1, YEAR))

But since the Tons/Vehicles is a measure, not a column, Power BI won´t let me do this. Can someone help me how to fix this?

Thanx in advance!

[sw123]

I do not have any visual yet, just trying to make the measure. Or could someone walk me through how to do this?

[v-xiaotang]

Hi @sw123 

Thanks for reaching out to us.

It is recommended that you change to a visual that supports measure as a trendline.

FYI: 15 Best Power BI Chart Types and Visual Lists - Learn | Hevo (hevodata.com)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.