I have column Value No Of hours present in a day..
I Need No Of hours present in last month value for each staff
please any one clarify my doubt
Solved! Go to Solution.
Depending on where you want your results, a required expression may vary.
If you want to show the result in the rows of the table you have [No Of hours] , then something like below will give you the result.
SUM(
SELECT(table[No Of hours],
AND(MONTH([date]) = (MONTH(TODAY()) - 1),
[employee] = [_THISROW].[employee]
)
)
)
Or rather if you have a separate table to store results with fields..
[id], [employee], [month], [No of hours], [result] (Edited: You only need [No of Hours])
Then the result col can be obtained by
SUM(
SELECT(data_table[No Of hours],
AND(MONTH([date]) = [_THISROW].[month],
[employee] = [_THISROW].[employee]
)
)
)
Depending on where you want your results, a required expression may vary.
If you want to show the result in the rows of the table you have [No Of hours] , then something like below will give you the result.
SUM(
SELECT(table[No Of hours],
AND(MONTH([date]) = (MONTH(TODAY()) - 1),
[employee] = [_THISROW].[employee]
)
)
)
Or rather if you have a separate table to store results with fields..
[id], [employee], [month], [No of hours], [result] (Edited: You only need [No of Hours])
Then the result col can be obtained by
SUM(
SELECT(data_table[No Of hours],
AND(MONTH([date]) = [_THISROW].[month],
[employee] = [_THISROW].[employee]
)
)
)
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |