Forum Discussion

jbrines's avatar
jbrines
Icon for Advocate III rankAdvocate 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
Icon for Advocate III rankAdvocate III
7 months ago

Hi BeaBF it works but not showing the correct results. Is it because the Actual Time in Results Data is a Messure?

 

How do you upload PBIX files to a message, so I can you show you.

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
7 months ago

jbrines probably you can't if you don't have this at the bottom of the reply:


Can i send in pvt my email address, or paste here the measure formula  based on my pbix file.
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
    Icon for Super User rankSuper User
    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!