How to choose first non blank column in DAX?

[Anonymous]

Hi,

Will be very happy if someone can help me

I need in last column (Freight) to be displayed first non blank value from columns (2022, 2021, 2020, 2019). I am struggling how to write it correct in DAX

Table:

what I need to get:

Thank you in advance

[Anonymous]

Hi @amitchandak ,

thanks for your reply!

I tryed, but coalesce is not available in Power Pivot. 

[amitchandak · Accepted solution]

@Anonymous ,

if(not(isblank([2022 freight])),[2022 freight],

if(not(isblank([2021 freight])),[2021 freight],

if(not(isblank([2020 freight])),[2020 freight],

if(not(isblank([2019 freight])),[2019 freight]))))

[Anonymous]

@amitchandak Thank you, thank you very much!

[amitchandak]

@Anonymous , Try like

coalesce([2022 freight],[2021 freight], [2020 freight], [2019 freight])