firstnonempty
1 Topic
Firstnonblank not working without month month column
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!Solved618Views0likes1Comment