locked
Create a column in DAX based on aggregate RRS feed

  • Question

  • Hello,

    I'm hoping for some help in Power BI!  Here's the scoop:

    My data is essentially cases/tickets that people file.  We are looking to create a benchmark.  One of the columns we have is "Days Open".  We would like to create a benchmark where we can say "Has the number of days this ticket been open more or less than the average + standard deviation of all tickets."  Is that doable?

    Additionally, we would like to add more conditions, like "as the number of days this ticket been open more or less than the average + standard deviation of all closed tickets within a certain tier."

    Is something like that available in DAX?  Or do you have any idea as to how I can create something like that?

    Thanks,

    Nick

    Friday, October 9, 2015 10:01 PM

Answers

  • Hi Nick, Yes this is doable with DAX and also with advanced M in Power Query, though DAX would be easier to implement. I suggest you re-post it in the PowerPivot forum and share the column names, so you can get an answer which is based on your actual table schema.
    Saturday, October 10, 2015 3:57 PM