Firstnonblank not working without month month column

[artlearning]

Hello everyone - I'm trying to get the very first month name where I have a transaction. I tried to use Firstnonblank but it's not working as expected. Here's my dataset

Customer	August, 2022	September, 2022	November, 2022	December 2022
A	1	1
B			5	5

I tried this expression 

Cust Firt Order:=FIRSTNONBLANK(Sales[Fiscal Month],[Lics]>0)

But is not working for all cases

Customer	Cust First Order
A	August, 2022
B	December, 2022

For customer A, I get the correct date since the first transaction ocurred in August, but for customer B, I'm getting the December date when I should get November.

Appreciate your help!

[amitchandak · Accepted solution]

@artlearning , Make sure you are using a date table , use date in place of month name, month name are not sortable , Create date from Month Year

calculate(firstnonblankvalues(Date[Date], [Value Measure]) )

or

calculate(firstnonblankvalues(Date[Date] ), [Value Measure]), filter( allselected(Table), Table[Customer] = max(Table[Customer]) ) )

Also, you can explore the Index function

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U