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

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    DimaMD  thank you for your reply i am taking date column in table visual from calendar date table and now spend values are  changing by date(actual table) slicer and planned values are changing by date(planned table) slicer whcih means table is not filtering only by one slicer 

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

      Anonymous that's right, my reports also use two date slices

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        DimaMD  cant we acheive this by using one slicer ?

         plus in your report have you calculated daily runrate ?

        if yes may I have pbix. file for the same