Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

need help please

ok, so I what i want to do is search the table below for items where the field = status and has a created date within 7 days, and i want to report on the new value and key.

 

is this difficult?

 

 

thank you in advance for any help anyone can provide.

 

Jeff

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Yes, it may be >= Today() -6, depend on need.

     

    Also, all measure in visual table should have same filter or use this measure as visual level filter

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Create a measure like this and use in visual or use as a visual level filter and check for non blank

     

    countrows(filter(table, Table[Created date] <= Today()  && Table[Created date] >= Today() -7))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak so if the table is called histories the line would be like this?

       

      7days = countrows(filter(Histories, Histories[CREATED] <= Today() && Histories[CREATED]] >= Today() -7))
      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        Anonymous , Yes, it may be >= Today() -6, depend on need.

         

        Also, all measure in visual table should have same filter or use this measure as visual level filter

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I tried this but it doesn't seem to do what i need, i want to report on the change in something like a matrix, where i can show the old status -> new status, so the output would look something like this, based on the table above.

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak after fudging around for a while i managed to get it to work, thanks.