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 performance i need to show what is the daily runrate should be to acheive plannd value.
thanks in advance.

 

 

  • DimaMD's avatar
    DimaMD
    3 years ago

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

    pbix file

28 Replies

  • 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 

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi Anonymous If you have a plan for only one date, you can break it into days, try this event

    VAR _plan = [_Plan margin]
VAR _2AmountDatesMount = DAY(EOMONTH(MIN('Календар'[Date]),0))
VAR _3PlanDates =DIVIDE(_Plan, _2AmountDatesMount)
VAR _4 = DATEDIFF( MIN('Dates'[Date]),MAX('Dates'[Date]),DAY)+1 
return
_3PlanDates*_4



    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago


      I have  tried this measure it is reflecting only for first day of the month ...how can i get it daily ?

       

      • DimaMD's avatar
        DimaMD
        Icon for Solution Sage rankSolution Sage
        3 years ago

        Anonymous You need to unlink the plan table from the date table