Forum Discussion

Tarak_G's avatar
Tarak_G
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Value needs to be passed from table to Query

Hi Team,   I've two tables . one table is Incidents and another one : SLA Duration table   Need to calculate whether incident is WithInSLA or OutOfSLA    SLA Table Time to Acknowledge No ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Tarak_G ,

     

    Not quite sure whether I have caught your point,you said :Need to Pass value from table based on severity and Kpi= TimetoMitigate,do you wanna create a column to get the value returned from "SLA Table"?

    Then you could create a column as below:

     

    _Duration = CALCULATE(MAX('SLATime'[Duration]),FILTER('SLATime','SLATime'[Severity]='Incidents'[Severity]&&'SLATime'[KPI]="Time to Mitigate"))

     

    And you will see:

     

     

     

    If I misunderstood your meaning,pls let me know.

     For the related .pbix file ,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

Tarak_G's avatar
Tarak_G
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Hi amitchandak ,

 

Here query means calculated column and attched pbix file.  I tried with lookupvalue but i was not able to get it. Can you help me on that ?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Tarak_G , Still not clear, But a new column like this in Incident table

     

    Column = SWITCH(TRUE(), ISBLANK([TTM]) , "Not Done" ,[TTM] > maxx(FILTER(SLATime, SLATime[KPI] ="Time to Mitigate"  && SLATime[Severity] = Incidents[Severity] ),SLATime[Duration]), "Out of SLA", "In SLA")