Forum Discussion
Solved
Conditions Query for Todays Date - 30 days Help Request
I'm currently trying to figure out if it's possible to update a Conditions field to allow for Todays Date 30 days. I'm currently Querying from an API in our Ticketing System with an addition cond...
lbendlin Thanks for the quick reply.I may have a different thought process.
Hi TechWolf ,
Regarding your question, you can refer to the following dax expression to realize it.
1. Use the following DAX expression to create a measure named ‘Last30Days’:Last30Days = VAR Today = TODAY() VAR StartDate = Today – 30 RETURN FILTER (‘TableName’,[dateEnterned] >= StartDate && [dateEnterned] <= Today)With this expression you can dynamically filter data up to 30 days old.
lbendlin Thanks for the quick reply.I may have a different thought process.
Hi TechWolf ,
Regarding your question, you can refer to the following dax expression to realize it.
1. Use the following DAX expression to create a measure named ‘Last30Days’:
Last30Days =
VAR Today = TODAY()
VAR StartDate = Today – 30
RETURN
FILTER (‘TableName’,[dateEnterned] >= StartDate && [dateEnterned] <= Today)
With this expression you can dynamically filter data up to 30 days old.