Forum Discussion

ritanoori's avatar
ritanoori
Resolver I
5 years ago
Solved

First non blank does not work

Hey everyone I'm trying to use first non blank in DAX. The value I'm trying to use is available in the other refresnced table but it's not working.  Almost tried everything.  Why is it not working...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ritanoori , if this is a new column this should work

    minx(filter(Ref_TMS_Reports, Ref_TMS_Reports[Correct Voucher ID] = Fact_GL[New PONumber ]),Ref_TMS_Reports[SHIPMENT_NUMBER])

     

     

    or

     

    minx(filter(Ref_TMS_Reports, Ref_TMS_Reports[Correct Voucher ID] = Fact_GL[New PONumber ] && not(isblank(Ref_TMS_Reports[SHIPMENT_NUMBER])) ),Ref_TMS_Reports[SHIPMENT_NUMBER])

amitchandak's avatar
amitchandak
Super User
5 years ago

ritanoori , if this is a new column this should work

minx(filter(Ref_TMS_Reports, Ref_TMS_Reports[Correct Voucher ID] = Fact_GL[New PONumber ]),Ref_TMS_Reports[SHIPMENT_NUMBER])

 

 

or

 

minx(filter(Ref_TMS_Reports, Ref_TMS_Reports[Correct Voucher ID] = Fact_GL[New PONumber ] && not(isblank(Ref_TMS_Reports[SHIPMENT_NUMBER])) ),Ref_TMS_Reports[SHIPMENT_NUMBER])

Anonymous's avatar
Anonymous
Not applicable
2 years ago

So glad I found this, thank you!!

 

FIRSTNONBLANK was returing values for certain Lookup cells but not the others...