Forum Discussion
Tim_H
Helper I
Helper IHow to create percentage trendline ?
Hi, I want to create a percentage trendline for all closed tickets in time I already created two tables in XLS to count tickets per day DaysTicket # 0 3 3 1 7 1 9 1 11...
Hi, Tim_H
Please correct me if I wrongly understood.
please check the below picture whether it is what you need.
total quantity cumulate =CALCULATE( [total quantity], FILTER(ALLSELECTED(Days_Table), Days_Table[Days] <= MAX( Days_Table[Days])))PBIX file link is down below.Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Jihwan_Kim
Super User
Super UserHi, Tim_H
Please correct me if I wrongly understood.
please check the below picture whether it is what you need.
total quantity cumulate =
CALCULATE( [total quantity], FILTER(
ALLSELECTED(Days_Table), Days_Table[Days] <= MAX( Days_Table[Days])))
PBIX file link is down below.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Tim_HHelper I
Helper Inot exactly how I dit it..but you really helped in finding the solution.