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.
Hello Team,
Need help to setup guage dasboard . The criteria as follows. I have 2 table - Table1 & Table2
Table1
Table2
WRT ticket type, priority and target time from table1 --> the data should met/unmet from table2.
Solved! Go to Solution.
- What is "Custom" on Table 2?
It's time format in h:nn:ss
I guess I'll have to assume that is the time to ticket resolution (1st ticket on the list was resolved in 28 seconds, etc). Given that assumption, use a calculated column
Met =
VAR __AllowedTime =
LOOKUPVALUE (
Table1[Target Time],
Table1[Ticket Type], Table2[Ticket Type],
Table1[Priority], Table2[Priority]
)
RETURN
IF ( Table2[Custom] < __AllowedTime, "Met", "Unmet" )
If this doesn't work, please share your pbix file, or share some data in a format that can be copied.
Hope this helps
David
Hi @Anonymous - you need to provide more information on what you are attempting to accomplish.
- What is "Custom" on Table 2?
- What defines met and unmet?
- Are you attempting to do this in PowerQuery/M, or with DAX?
- What kind of visuals are you hoping to use with this data?
Also, please put data in a format that can be copied, or provide a link to you pbix file. Refer to this link for other tips: How to Get Your Question Answered Quickly
David
- What is "Custom" on Table 2?
It's time format in h:nn:ss
- What defines met and unmet?
If table1 target time is <= custom in table2 with respect to ticket type from both table1 & table2 then its MET
- Are you attempting to do this in PowerQuery/M, or with DAX?
With DAX
- What kind of visuals are you hoping to use with this data?
Having plan to put filter with Met/UnMet or with Guage % value
- What is "Custom" on Table 2?
It's time format in h:nn:ss
I guess I'll have to assume that is the time to ticket resolution (1st ticket on the list was resolved in 28 seconds, etc). Given that assumption, use a calculated column
Met =
VAR __AllowedTime =
LOOKUPVALUE (
Table1[Target Time],
Table1[Ticket Type], Table2[Ticket Type],
Table1[Priority], Table2[Priority]
)
RETURN
IF ( Table2[Custom] < __AllowedTime, "Met", "Unmet" )
If this doesn't work, please share your pbix file, or share some data in a format that can be copied.
Hope this helps
David
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |