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!

jbrines's avatar
jbrines
Advocate III
7 months ago

I also menat to say that Actual Time in Power BI is a measure between Created Date and Closed date using NETWORKDAYS

  • v-echaithra's avatar
    v-echaithra
    Community Support
    7 months ago

    Hi jbrines ,

    This is possible, and you do not need multiple columns like in Excel.
    The key is to model it correctly and use a measure-to-measure comparison.


    Create a Category dimension

    Create a DimCategory table containing distinct Category


    Results[Category] > DimCategory[Category]

    SLATime[Category] > DimCategory[Category]

    This creates a proper star schema, which is required for clean DAX.

    Keep Actual Time as a measure
    Since Actual Time is already a measure (calculated using NETWORKDAYS), that’s perfectly fine.

    Create an SLA Time measure

    SLA Time =
    SELECTEDVALUE ( SLATime[Sum of Time (days)] )


    Create the SLA Met measure

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

    If possible, could you please provide more details about your data?

    How to provide sample data in the Power BI Forum

    You can refer the following link to upload the file to the community.
    How to upload PBI in Community

    Thank you.

    • jbrines's avatar
      jbrines
      Advocate III
      7 months ago

      Hi v-echaithra , Sorry I don't have a lot of experinec with Power BI especially Dimentions.

       

      Create a Category dimension - Is this a new Dimention Table called Category?

      Create a DimCategory table containing distinct Category - My SLATime Data table contains distinct Categories.

       

      Is there a way I can send you the pbix so you can then show me what you mean?