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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      DimaMD  values are coming incorrect now 

       

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

        Anonymous add a stacker with dates from the plan and from the actual (or date table)

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

    Anonymous add a sliser with dates from the plan and from the actual (or date table)