Forum Discussion
Solved
Lookup help
Hi guys, I am converting an excel spreadsheet (below) in to Power BI. I have a Table names SLATime which is a list categories with an SLA Time for each category. I want to create ...
Hi,
Based on the 2 tables that you have shared, show the expected result.
Hi Ashish_Mathur ,
Basically in the mesure column I want it to look at the Category in the results data table, compare it to the Category on Table SLATime Data then use the Sum of Time field to subtract from the Actual Time on the results data table if it is zero or poistive then the outcome should be Yes, if it is a negative the outcome should be No. The Actual Time Column the Results Table in Power Bi is currently a messure column
I hope that makes sense.
Sorry but cannot understand your response.