Forum Discussion
SteelChampzz
3 years agoHelper II
How 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 ...
- 3 years ago
Hi SteelChampzz
You can tryAmount2 =
VAR Amount = [Amount]
RETURN
IF ( Amount > 0, Amount )
tamerj1
3 years agoCommunity Champion
Hi SteelChampzz
You can try
Amount2 =
VAR Amount = [Amount]
RETURN
IF ( Amount > 0, Amount )
SteelChampzz
3 years agoHelper II
That worked PERFECTLY!
thank you