Forum Discussion
Solved
SumIF less than a specified number
Hi all I have a table that contains data pulled from our time recording system. After some manipulation I have these fields: Total_Hours_Per_week Hourly_Rate Max_hours_Per_Month Each staff ...
Do you have a DimDate table?
You can try something like;
Pay =
VAR _MaxHrs = MAX(table[hours per month])
RETURN
IF( sum(Table[hours]) >_MaxHrs , _MaxHrs* MAX(Table[Hourly Rate]),
sum(Table[hours] *MAX(Table[hourly rate])
How have you done the calculations for the three columns you already have? There may be a more efficient way to get this result than using those calculations.
You can try something like;
Pay =
VAR _MaxHrs = MAX(table[hours per month])
RETURN
IF( sum(Table[hours]) >_MaxHrs , _MaxHrs* MAX(Table[Hourly Rate]),
sum(Table[hours] *MAX(Table[hourly rate])
How have you done the calculations for the three columns you already have? There may be a more efficient way to get this result than using those calculations.