Forum Discussion

bgepps's avatar
bgepps
Frequent Visitor
9 years ago

Removing status' from average time calc

In my data set, i have the following columns of data that are being pulled in via a database.   Job Status Status start date Status end date   I have been able to calculate the average time for...
Need Help
tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi bgepps,

 

Choose Edit Query, right click in Job Status column, you will have some filter options and please try with it. if it's working for your case we could try another approach with DAX 

  • bgepps's avatar
    bgepps
    Frequent Visitor
    9 years ago

    Hi tringuyenminh92 - would this remove those status' from the other reports i have in my deck, though?

     

    Or would i have to copy the table, and then filter out the status in the second table, with the same time difference formula's mentioned in my original post?

     

    Appreciate your help,

     

    Ben

    • tringuyenminh92's avatar
      tringuyenminh92
      Memorable Member
      9 years ago
      Hi bgepps,

      Yes, this is filtering dataset, reports using this source (this table) will be filtered these data.
      • bgepps's avatar
        bgepps
        Frequent Visitor
        9 years ago

        Hi tringuyenminh92 - so if i follow my suggestion above, it should give me the information i require, and continue updating as the SQL database is populated with data?

         

        If so i will try copying to a new table later and will keep you updated.

         

        Thanks,

         

        Ben