Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Daily Required Run rate

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 p...
  • DimaMD's avatar
    DimaMD
    3 years ago

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

    pbix file

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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