topic Re: Fix Line Graph for breaks in data, replace blank with 0, then leave blank for months after last sale in DAX Commands and Tips

Fix Line Graph for breaks in data, replace blank with 0, then leave blank for months after last sale

watje255_ju — Tue, 16 Aug 2022 05:34:26 GMT

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!

Re: Fix Line Graph for breaks in data, replace blank with 0, then leave blank for months after last sale

tamerj1 — Tue, 16 Aug 2022 06:32:32 GMT

Hi 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

Re: Fix Line Graph for breaks in data, replace blank with 0, then leave blank for months after last sale

watje255_ju — Tue, 16 Aug 2022 21:46:03 GMT

Thank you so much!!