Forum Discussion
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? ...
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
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))
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