Solved: Showing rows with a start date older than 50 days

Anonymous · ‎04-26-2017

So I have a measured column which calculates the days that have passed since the a new item was created:

Age = DATEDIFF(Table1[DateTimeColumn],TODAY(),DAY)

I have added a card visual to show the total number of items, now I want to add another card which only shows items older than 50 days.

If anyone could help with this I'd appreciate it.

TomMartens · ‎04-26-2017

Hey,

I would create another Calculated Column, the same formula.

Add this Column to the Visual Filter Section of the Card Visual apply the filter "is greater than" 50, in my opinion this should work.

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

TomMartens · ‎04-26-2017

Hey,

I would create another Calculated Column, the same formula.

Add this Column to the Visual Filter Section of the Card Visual apply the filter "is greater than" 50, in my opinion this should work.

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Showing rows with a start date older than 50 days