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 ...
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!
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!
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.
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!