Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
did you try something like below
count({<ExpirationDate={"<$(=Date(today(),'YYYY-MM-DD'))"}>}IDs)
p.s. ensure that the ExpirationDate column type is date
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])?
did you try something like below
count({<ExpirationDate={"<$(=Date(today(),'YYYY-MM-DD'))"}>}IDs)
p.s. ensure that the ExpirationDate column type is date