Forum Discussion

jbrines's avatar
jbrines
Advocate III
7 months ago
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 ...
Need Help
  • BeaBF's avatar
    BeaBF
    7 months ago

    jbrines Here is the final PBIX with the correct logic.

     

    BBF


    💡 Did I answer your question? Mark my post as a solution!

    👍 Kudos are appreciated

    🔥 Proud to be a Super User!

BeaBF's avatar
BeaBF
Super User
7 months ago

jbrines Hi!
Here the calculated column:

FINAL AGGREGATED =
VAR SLA_DAYS =
    LOOKUPVALUE(
        'SLA Time'[Sum of Time (days)],    
        'SLA Time'[Category],              
        'Results Data'[Category]            
    )
VAR DELTA =
    'Results Data'[Actual Time] - SLA_DAYS
RETURN
IF(DELTA > 0, "YES", "NO")

I attack also the pbix file! 🙂
Let me know
BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

BeaBF's avatar
BeaBF
Super User
7 months ago

jbrines You can also do it without the lookup function, but using relations and RELATED function
I attack the same pbix with the second logic implemented

 

BBF


💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!