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!

cengizhanarslan's avatar
cengizhanarslan
Super User
7 months ago

Best option would be creating your model in star-schema(create DimCategory and create relations from dim to Fact tables) and then usign the measure below:

 

SLA Met =
IF(
    SELECTEDVALUE(Results[Actual Time])
        <= SELECTEDVALUE(SLATime[SLA Time]),
    "Yes",
    "No"
)