Forum Discussion
SteelChampzz
Helper II
3 years agoHow to filter dates with no values
I want to be able to add a filter to the measure so that any date that has $0, doesn't show.
Or
would it be easier for me to filter them in the visual, If so how would I do that?
Thanks to anyone that helps
Hi SteelChampzz
You can tryAmount2 =
VAR Amount = [Amount]
RETURN
IF ( Amount > 0, Amount )
2 Replies
- tamerj1
Community Champion
Hi SteelChampzz
You can tryAmount2 =
VAR Amount = [Amount]
RETURN
IF ( Amount > 0, Amount )- SteelChampzz
Helper II
That worked PERFECTLY!
thank you