Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
hi, have a little issue with a formula im trying of get the max value of a summarize column is for propourses of OT but the formula is taking all values over 40 instead just the max value how i can fix it here mi example table
@Anonymous Use MAXX to get the max of all the values and then use that to compare with the current value.
@Greg_Deckler how i can do that the maxx need a expresion wich is not resulting in what i want because i want whe max of my cumulative by the worker id by the week i need to apply the filter first
this formula is giving me the correct number but is takin all values over 40 i just want the max value over 40
@Anonymous Like this:
Column =
VAR __WorkerID = [worker id]
VAR __Week = [week]
VAR __Max = MAXX(FILTER('Table',[worker id] = __WorkerID && [week] = __Week),[Cumulative hours for week])
RETURN
IF([Cumulative hours for week] = __Max,__Max - 40, BLANK())
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
11 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |