Get a new data objective based on previous month performance

[Anonymous]

Hello all,

I want to set a new objective (number of files and time allowed) based on the previous month results.

My months table has every month starting on the 15th of each month, because all the tasks are done during this period, then resets.

I don't know how to set my new date up, maybe somebody can help me ?

Thank you ! 

[v-xuding-msft]

Hi @Anonymous ,

For the scenario, I can't create a sample to implement it. Can you please post some sample data and the expected results? Then we can help you as soon as possible.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,

For example :

> July period : july 15th to august 14th

For July, first "Number of files to edit" is set up manually.

During "July", "Number of files edited" about "Client"= 15

Then I would like 15 to become my "Number of files to edit" for the next period, and so on.

Same thing for "Estimated time" and "Time spent".

All my "Number of files edited" and "Time spent" data comes from a MS Forms that automatically sends to my Work Table, these informations + the day and hour the Forms was completed (which becomes "Day of edition" and allows me to have a calendar where I can see when, for who, by who and how many files have been done)

My Power BI is such a mess right now, I hope I explained it well... Providing the file won't really help...

[Anonymous]

Actually I just found a measure that works but the date filter doesn't apply, it goes like :

BS Prédictif = CALCULATE (

SUM ( Traitements[Nb_BS_édités] );

DATEADD ( Dates[Période sociale]; -1; MONTH )

)

But when I filter it says that my DATEADD value waits for a date row not unique, discontinued or having an hour data.

I also tried this one :

BS Prédictif 2 = CALCULATE(SUM(Traitements[Nb_BS_édités]); PREVIOUSMONTH(Dates[Période sociale]))

But it doesn't show any result, and I don't know why, I think I'm missing something...

Basically, here's what I want to achieve, knowing that my months are starting every 15th and ending the 14th of the next one.