Forum Discussion
watje255_ju
Helper III
Helper IIIFix Line Graph for breaks in data, replace blank with 0, then leave blank for months after last sale
Hello, I have used an IF funtion to replace the blank gross margin % (for months when there is no sales) for 0, so that my line graph doesnt break. However I then want the months in which t...
Hi watje255_ju
I hope this is what your looking for https://www.dropbox.com/t/6CtxqpNbKlUr0hd7Stop GM % after last sale = Var LastSalesDate = CALCULATE ( MAX (Margin[Month] ), REMOVEFILTERS ( ) ) VAR Result = IF ( MAX ( DimDate[DateKey]) <= LastSalesDate, [GM% with 0 replacing blank] ) RETURN Result
tamerj1
Community Champion
Community ChampionHi watje255_ju
I hope this is what your looking for https://www.dropbox.com/t/6CtxqpNbKlUr0hd7
Stop GM % after last sale =
Var LastSalesDate = CALCULATE ( MAX (Margin[Month] ), REMOVEFILTERS ( ) )
VAR Result =
IF ( MAX ( DimDate[DateKey]) <= LastSalesDate, [GM% with 0 replacing blank] )
RETURN
Result
watje255_juThank you so much!!