Forum Discussion

sananakbar56's avatar
sananakbar56
Frequent Visitor
4 years ago
Solved

Use FIRSTNONBLANK() with String and Date

Hi all, I need help with using FIRSTNONBLANK() sorting a string column by date. Unfortunately, when I sort it by the string, it returns me the min(string) because A is lower than B and B lower than C...
  • colacan's avatar
    colacan
    4 years ago

    Hi sanaankbar56,

    I was very clear with your requirement and I have tested it as below.

     

     

    from above table, the "FirstRetnFruit" is the measure for for it.

    The code is as I showed at my previous answer.

     

    Hope this helps you. Thanks

colacan's avatar
colacan
Icon for Resolver II rankResolver II
4 years ago

Hi sanaankbar56,

I was very clear with your requirement and I have tested it as below.

 

 

from above table, the "FirstRetnFruit" is the measure for for it.

The code is as I showed at my previous answer.

 

Hope this helps you. Thanks

sananakbar56's avatar
sananakbar56
Frequent Visitor
4 years ago

It worked now. We were missing one filter. 

 

FirstReturnProduct =
           CALCULATE(
                      FIRSTNONBLANKVALUE(
                            Fruits[TransactionDate],
                            SELECTEDVALUE( fruits[Purchase] )
                      ),
                     ALLEXCEPT( Fruits, Fruits[CustomerID] ), Fruits[TransactipnType]  = "Return"
           )
 
Thanks a lot for your help. I have accepted this as solution.