The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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 ,
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]))))
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |