Greater Than Today

[Anonymous]

I am trying to only sum subscription amounts where the subscription end date is greater than today to get a true view of our customer subscription amount day by day.

I referenced this post: Greater than today date

to create the set analysis below, but it is not working.

Any ideas?

=sum({$< [Subscription End Date] = {">= $(=Date(Today(),'MM/DD/YYYY'))"}>}[Amount])

- dave

[sunny_talwar]

Is Subscription End Date a date or timestamp field? Its format is MM/DD/YYYY?

[Anonymous]

This is how I formatted Subscription End Date in the load script

Date("Subscription End Date",'MM/DD/YYYY') as [Subscription End Date],

[sunny_talwar]

Try this:

Date(Floor("Subscription End Date"),'MM/DD/YYYY') as [Subscription End Date],

[Anonymous · Accepted solution]

Solved it. I had to delete the spaces in the set analysis between all of the different characters. Seems like the syntax is very sensitive.

[Anonymous]

I had spaces in set analysis that were preventing it from working. Thank you for your feedback.