Accumulated

[Syndicate_Admin]

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

[Jihwan_Kim]

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 

[Syndicate_Admin]

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

https://we.tl/t-Ezps2xxUP0

[Jihwan_Kim]

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!!

[Syndicate_Admin]

Hello

been reviewing the formulas and it's not exactly what I want. I'm explaining the most wrong. I don't want the accumulated one I want the global. For example:

1. If filter on the slicer dates date 04-01-2021 in the gauge graph should give me 18% (which is the performance of that week) but if I filter two weeks 04-01-2021 and 11-01-2021 (18 % and 53%) and the graph of guge should give me the overall of the two of them I do not know if it is the sum between the weeks 36%?

and if I don't filter any date I should give the performance globar in the 9 weeks

I don't know if you'll explain it to me right.

Best regards

Thank you

Stephanie Falvay

[Jihwan_Kim]

Hi, @Syndicate_Admin 
Thank you for your feedback.

I am not sure if I understand correctly, but is it OK with you to share how you calculate the performance? Without knowing this, I cannot know what is 100%. 

If I may just assume the 5.58 is 100%, then the first week is not 18%

[amitchandak]

@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])))