I am facing an issue while applying conditional formatting. Please find below requirement with expected output and current output.
Note: 1) The values are sum of sales.
2) Blank means product was not available for a particular week hence blank
3) Blank can't be replaced with 0. That's the business requirement
Expected : The requirement is when week number<= current week, then color code yellow else blue.
But instead of the above, I get this:
Issue: The DAX is not taking blank values into consideration. I have applied 3-4 methods. But none of them are working on blank values.
I have tried: if( week number<= current week && Sum(Sales)) = BLANK(), then color code yellow else blue.
Can anybody please let me know the solution of this problem?