Sold/Not Sold/New Sold in DAX (A third parameter based on a date and UNICHAR function)

[Anonymous]

Hi.
I have created a measure that shows which products we have sold or not sold to a customer:

Sold/Not Sold =

IF(SUM('Table1'[Sales Quantity])>0,"SOLD",UNICHAR(128310))

First: I just discovered UNICHAR. And I can only find a UNICHAR code for a red diamond shape (128310), does anyone know about a code that shows a green icon, so I dont need to put in "SOLD"? In my matrix it looks like this now:
Second:
I need some help with the Sold/Not Sold measure to add an extra criteria. Ideally I want to have it like this:
Sold = Some kind of a geen icon (Worst case it can return "SOLD")
Not Sold = Some kind of a red icon (Already have this sorted in a way...)
New Sold = This should tell me that if a product is never sold before, but is sold from or after 29.04.2021 it will be a yellow icon (in worst case it can return "NEW SOLD").
For example: If "Yam" (in the matrix) is sold 29 april 2021 it should return a yellow icon/"NEW SOLD" when I filter the report on april 2021.
If I filter the report on march 2021 it should return the red icon, because its Not sold in that particular period that I have chosen. 

Appriciate any help!

[Anonymous]

@amitchandak do you have any idéa for how I can write this measure?

[Greg_Deckler]

@Anonymous - Well, you could use conditional formatting along with a UNICHAR character to get the different colors - Unichar Green circle light - Microsoft Power BI Community

Also, 9989 is a green check mark box. Here is the full UNICODE characters list: Basic Latin — ✔️ ❤️ ★ Unicode Character Table (unicode-table.com)

For New Sold you could do a FILTER on the table for dates previous to that day and if the COUNTROWS of that filtered table ISBLANK then it would be new sold.

[Anonymous]

@Greg_Deckler OK, thanks!

Could you please show me an example of how this can look like in this measure?:

Sold/Not Sold/New Sold =

IF(SUM('Table1'[Sales Quantity])>0,UNICHAR(9989),UNICHAR(10060))