3 collumn with values where only 1 column has values, add a column with 1 value

[Marcel_Graumans]

I have 3 columns where only 1 column is filled, I want to see this value in an added column in a dax formula

[v-tianyich-msft · Accepted solution]

Hi @Marcel_Graumans ,

Try expression below:

Measure = IF(MAX('Table'[Begroting])=BLANK()&&MAX('Table'[Meerwerk])=BLANK(),MAX('Table'[Budget]),MAX('Table'[Begroting])+MAX('Table'[Meerwerk]))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Marcel_Graumans]

Is there also a solution between measurements, this solution is for colums

[v-tianyich-msft]

Hi @Marcel_Graumans ,

I made simple samples and you can check the results below:

Column = 
VAR _VIRTUAL = ADDCOLUMNS('Table (2)',"C1_1",IF('Table (2)'[C1] = BLANK(),0,1),"C2_1",IF('Table (2)'[C2] = BLANK(),0,1),"C3_1",IF('Table (2)'[C3] = BLANK(),0,1))
VAR _INDEX = 'Table (2)'[Index]
RETURN
SUMX(FILTER(_VIRTUAL,[Index] =_INDEX && [C1_1]+ [C2_1] + [C3_1] = 1),[C1]+[C2]+[C3])

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Marcel_Graumans]

thats not what i mean i have a import and now i want to adit a column 

if begroting and meerwerk is filled then adit in column new if not then budget in new column

Budget	Begroting	Meerwerk	New
€ 260.000,00			€ 260.000,00
€ 260.000,00			€ 260.000,00
€ 260.000,00			€ 260.000,00
€ 6.500,00	€ 6.253,32		€ 6.253,32
€ 16.500,00	€ 7.797,14		€ 7.797,14
€ 6.500,00	€ 6.253,32		€ 6.253,32
€ 7.500,00	€ 7.302,52		€ 7.302,52
€ 3.500,00	€ 5.838,58		€ 5.838,58
€ 1.760,00	€ 1.461,93		€ 1.461,93
€ 5.000,00	€ 6.682,68		€ 6.682,68
€ 7.500,00	€ 8.840,81		€ 8.840,81
€ 2.000,00	€ 2.648,40		€ 2.648,40
€ 0,10	€ 0,00		€ 0,00
€ 7.500,00	€ 5.451,49		€ 5.451,49
€ 1.700,00	€ 1.696,50		€ 1.696,50
€ 3.500,00	€ 3.489,51	883,74	€ 4.373,25
€ 4.500,00			€ 4.500,00
€ 2.500,00			€ 2.500,00
€ 0,10			€ 0,10
€ 2.500,00			€ 2.500,00
€ 2.500,00			€ 2.500,00
€ 3.500,00			€ 3.500,00
€ 3.500,00			€ 3.500,00

[v-tianyich-msft]

Hi @Marcel_Graumans ,

You can refer to the following results:

Measure = IF(MAX('Table'[Begroting])=BLANK(),MAX('Table'[Budget]),MAX('Table'[Begroting]))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Marcel_Graumans]

it doesn't work i have 1 column extra called meerwerk total 3 colums

[v-tianyich-msft · Accepted solution]

Hi @Marcel_Graumans ,

Try expression below:

Measure = IF(MAX('Table'[Begroting])=BLANK()&&MAX('Table'[Meerwerk])=BLANK(),MAX('Table'[Budget]),MAX('Table'[Begroting])+MAX('Table'[Meerwerk]))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Marcel_Graumans]

nope i get this result sorry its in dutch

[Marcel_Graumans · Accepted solution]

i fix it works now