Counting the number of records before an Expiration Date

[lernherk]

Hi all, I have column called ExpirationDate that's in YYYY-MM-DD format. I am simply trying to create a measure for a gauge chart that will count all the records that have an ExpirationDate before today.  I've tried a number of things, but none of it seems to be working. Any help is appreciated.

Thanks!

[alexpanjhc]

Can you add a line in your script something like:

If ([expiration date]<today(),1 ,0) as [Expired Counts]

in your measure, count( [Expired Counts])?

[dplr-rn · Accepted solution]

did you try something like below

count({<ExpirationDate={"<$(=Date(today(),'YYYY-MM-DD'))"}>}IDs)

p.s. ensure that the ExpirationDate column type is date