Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i'm trying to find if a client goes over a threshold of hours by quarter. Here is the table i'm working with. I'm completely lost on this one
Solved! Go to Solution.
Hi,
Try creating this measure
Over/Under Threshold = if(SUM(Table1[Hours])>MAX(Table1[Threshold]),"Over","Under")
Add it to a table visual and filter the Over/Under Threshold to contains Over
Close, but if you look carefully each of the project id's have a different threshold. I need it to be calculated for each individual threshold
Hi,
Try creating this measure
Over/Under Threshold = if(SUM(Table1[Hours])>MAX(Table1[Threshold]),"Over","Under")
Add it to a table visual and filter the Over/Under Threshold to contains Over
Close, but if you look carefully each of the project id's have a different threshold. I need it to be calculated for each individual threshold
Hi @JoeKat07,
You have resolved your issue? If not, you'd better list the expected result in an example. So that we can post the solution which is close to your requirement.
Thanks.
Angelia
Hi,
The formula calculates the threshold of each Project ID, year, and Quarter when put in a table visual with these values.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |