Daily Required Run rate

[Anonymous]

Hello ,
I want to add a calculated column of the daily  required run rate by the company. My data looks like below.
I have 2 tables ( 1 for acheived data and other for planned data ) to check the performance i need to show what is the daily runrate should be to acheive plannd value.
thanks in advance.

[Anonymous]

@DimaMD  No problem ...Achieved spends is spends column in acheived sheet and it corresponds to "spend" column in Planned sheet

[Anonymous]

@DimaMD  Any luck on this ?

[DimaMD · Accepted solution]

@Anonymous Check out the attached file and tell me if this is your desired result!

pbix file

[DimaMD]

HI, @Anonymous Currently, there are several ideas we are trying to implement. 

[Anonymous]

@DimaMD  sharing my dymmy data with you please check 

https://globalappsportal-my.sharepoint.com/:f:/g/personal/prajakta_keni_dentsu_com/Eqg95-48_1xLvywdd...

[DimaMD]

Hi @Anonymous  Do you have a planned amount of 200,000 for September?

[tamerj1]

Hi @Anonymous 
Are the two tables connect with a relatioship? If so, what type of relationship and based on whih column? Do you have a date table? Can you please provide sample of the source data along with the expected result? The calculated column need to be created in which table?

[Anonymous]

hello thank you for your reply firstlt there is no relation between twi tables except date column and I am getting achived values on DAILY basis and planned values on MONTHLY basis attatching both the data tables along with the desired results