Forum Discussion
Accumulated
Hello
to see if you can help me with this doubt I have. I have a table with ID, dates per week, and performance (which is already calculated to me), I need to add up every week to get the accumulated one out and then pass it on to %, but it gives me more than 100%
do you have an idea?
Best regards
6 Replies
Syndicate_Admin , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Usually you accumulative like
With date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
without date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))
Hi, Syndicate_Admin
I hope the below is what you are looking for.
the link to the sample PBIX file is down below.
You can check all measures in the file.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
https://www.dropbox.com/s/uiawdrikik1qtap/SyndicateAdmin%202021%200322.pbix?dl=0
Hello
it's not really what I'm looking for. I attach the file and inside there's a note explaining what I'd like to get
Thank you
Hi, Syndicate_Admin
I tried to google-translate your note.
Please correct me if I misunderstood.
Please kindly check the below picture whether it is what you are looking for.
I hope it helps.
I updated the file and please check the link below.
https://www.dropbox.com/s/uiawdrikik1qtap/SyndicateAdmin%202021%200322.pbix?dl=0
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
