Forum Discussion
met/unmet data table
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.
- 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
3 Replies
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