Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running total on specific year

Hi everyone,    I am trying to display on the same chart the running total of the number of my files for 2020 and 2021 and this month by month.   I created a measure that gives me the running tot...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous try this:

     

    Running Total =
CALCULATE(
COUNT(t_divers_sinistres[sinistre_numero]),
DATESYTD(Calendar[Date])
)

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous ;

I am not very clear about your table, such as what fields your x-axis and legend are? can you provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data .
or provide a simple example (.pbix)?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-yalanwu-msft,

     

    Consider that I have two tables : 

    The first one is a simple calendar table

    The second one contains all my files since 2019 with the name of the file and its date (of creation).

     

    The relation between these two tables is made between the column date of my calendar table and the creation date column of the second table.

     

    I want to display on a same chart the running total of the number of my files for the year 2020 and for the year 2021 (like on the picture above). The x axis would be the month column of my calendar table.

     

    Is that clear ?