Forum Discussion
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 there are no sales to return blank, rather than 0, can I please help with this? It seems that when using the IF function blank replacement, all subsequent months are 0, not blank, even when filtering for last sales.
So ideally, the measure, Stop GM% after last sale would be blank from Aug 22 onwards.
Measures
Thanks!
https://1drv.ms/u/s!As8wMr9_bgGrgWstsIAjHqF-oJOI?e=WG8HNb PBIX file link here
Thanks!
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
2 Replies
- tamerj1
Community Champion
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
watje255_juThank you so much!!