Forum Discussion

Tim_H's avatar
Tim_H
Icon for Helper I rankHelper I
5 years ago
Solved

How 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...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Tim_H 

Thank you for your information.

Is it OK with you to share your sample data?

It helps me a lot to look into it with a clear idea.

Thank you very much.

Tim_H's avatar
Tim_H
Icon for Helper I rankHelper I
5 years ago

I have to see how to create a sample from the whole pibx..current PIBX has +400k lines and +200 columns wit some restricted data (GDPR).