Forum Discussion

DMB90's avatar
DMB90
Icon for Helper II rankHelper II
6 months ago
Solved

Looking for Specific Formula Assistance

Hello, I want to create a formula to basically state:   Calculate the sum of Actual Design hours (column already created) for a specified date range (3/1/2025 to 5/31/2025) and for the correspondi...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 months ago

    DMB90 , Try below, assuming you have date table 

    Budget Status =
VAR _ActualHours=
    CALCULATE(SUM('FactTable'[Actual Design Hours]),'FactTable'[Activity Type] = "Control",DATESBETWEEN(
            'Calendar'[Date],DATE(2025,3,1), DATE(2025,5,31) ))

VAR _AvgBudget =
    CALCULATE(
        AVERAGE('FactTable'[Budgeted Design Hours]), 'FactTable'[Activity Type] = "Control")

RETURN
    IF(_ActualHours > _AvgBudget,"Over Budget","Within Budget" )
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 months ago

DMB90 , Try below, assuming you have date table 

Budget Status =
VAR _ActualHours=
    CALCULATE(SUM('FactTable'[Actual Design Hours]),'FactTable'[Activity Type] = "Control",DATESBETWEEN(
            'Calendar'[Date],DATE(2025,3,1), DATE(2025,5,31) ))

VAR _AvgBudget =
    CALCULATE(
        AVERAGE('FactTable'[Budgeted Design Hours]), 'FactTable'[Activity Type] = "Control")

RETURN
    IF(_ActualHours > _AvgBudget,"Over Budget","Within Budget" )