Solved: How to choose first non blank column in DAX?

Anonymous · ‎03-10-2022

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

amitchandak · ‎03-11-2022

@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]))))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

Anonymous · ‎03-11-2022

Hi @amitchandak ,

thanks for your reply!

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

amitchandak · ‎03-11-2022

@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]))))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Anonymous · ‎03-11-2022

@amitchandak Thank you, thank you very much!

amitchandak · ‎03-11-2022

@Anonymous , Try like

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here