Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New Column guidance

I'm working on a dashboard using a gauge and need to accommodate a scenario in which a job doens't kick off. I have a column 'Expected Run Time' that is elapsed hours, mins, seconds -  example: 02:4...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I was able to get this DAX to work. I'm still working through getting the differences in the runtimes to be displayed as well. 

     

    Delay = IF([Status] ="Failed", "999", (IF([RunTime]>[AvgRunTime],"120","1")))
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the suggestions, however since I had complete control over the SQL I solved it there.