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?   ...
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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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))