Forum Discussion
Solved
table filter
Hi I am new to Power bi I have a table filtering weekly hours for all staff from daily timesheets into weeks using a date table to get week numbers and sum the hours for the week, and currently hig...
Use a "What-if" numeric parameter for that.
Hi Ibendlin
did you get my reply and sample data, only noticed its not swing on the topic thread?
No. Please try again.
so I have data below in a table
NAME: hours worked
WK1 wk 2 wk 3
xxx 50 65 50
want to filter a table to show rows where any column in it is over 55 for hours worked
Name Current week Sum of Regular Hours ttrob Grxyyxthd 42 48.81 ttrob Grxyyxthd 44 56.83 ttrob Grxyyxthd 42 20.2 tbzxrthwtb Htddtb 43 12.00 tbzxrthwtb Htddtb 44 3.00 tztw Gutdt 42 23.37 tztw Gutdt 43 36.08 tztw Gutdt 44 46.46 tztw Ptrtrxzgt 42 36.62 tztw Ptrtrxzgt 43 34.45 tztw Ptrtrxzgt 44 48.98 tztlt Pxtwtb 42 47.91 tztlt Pxtwtb 43 50.87 tztlt Pxtwtb 44 47.88 tztlt Pxtwtb 43 11.02 tzrxtb Woollty 42 46.24 tzrxtb Woollty 43 48.80 tzrxtb Woollty 44 47.69 tltb Htywtb 42 23.51 tltb Htywtb 43 24.10 tltb Htywtb 43 11.75 tltb Htywtb 44 24.2 tltb Jtyytry 42 20.12 tltb Jtyytry 44 20.40 tltb Wxlkxbd 42 20.02 tltb Wxlkxbd 43 20.50 tltb Wxlkxbd 44 20.25 tltx Kbxght 42 32.55 tltx Kbxght 43 31.15 tltx Kbxght 44 41.77 twtbzt tttob 42 36.00 twtlxt Cltrkt 42 22.00 twtlxt Cltrkt 43 23.02 twtlxt Cltrkt 44 44.20 twjtz tlx 42 40.50 twjtz tlx 43 37.17 twjtz tlx 44 11.83 twy wttchtw 42 12.35 twy wttchtw 43 48.35 tbzrt Browb 42 27.83 tbzrt Browb 43 19.07 tbzrt Browb 44 2.12 tbzrtw Grxwtd 42 52.35 tbzrtw Grxwtd 43 51.22 tbzrtw Grxwtd 44 36.85 tbzrtw Wtlburtob 44 22.63 tbzrtw Wtltob 42 12.00 tbzrtw Wtltob 44 12.50 tbzy dwxth 42 22.05 tbzy dwxth 43 35.05 tbzy dwxth 44 11.03 tbgtlt Ltwrtbct 42 39.86 tbgtlt Ltwrtbct 43 23.31 tbgtlt Ltwrtbct 44 24.42 tbgtlt dttvtbtob 42 47.68 tbgtlt dttvtbtob 42 11.25 tbgtlt dttvtbtob 43 43.39