The greater than or equal operator for a date difference in gallery is not working
I have a custom gallery with a Label field named Days.
I put the following for the Text property which works : DateDiff(ThisItem.Date,Now())
I put the following for the color property which doesn't work: If(Days.value >= 5, Red, Green). I also tried If(Days.text >= "5", Red, Green)
What am I doing wrong?
Go to Solution.
Because Days is a unit type that's associated with the DateAdd function, I would name your label LabelDays rather than Days.
Once you do this, the following syntax should work:
If(Value(LabelDays.Text) >= "5", Red, Green)
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand