Forum Discussion
Lookup help
I also menat to say that Actual Time in Power BI is a measure between Created Date and Closed date using NETWORKDAYS
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.
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?