topic 3 collumn with values where only 1 column has values, add a column with 1 value in DAX Commands and Tips

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

Marcel_Graumans — Tue, 16 Apr 2024 08:36:39 GMT

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

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

Anonymous — Wed, 17 Apr 2024 08:09:01 GMT

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.

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

Marcel_Graumans — Wed, 17 Apr 2024 09:38:03 GMT

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

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

Anonymous — Thu, 18 Apr 2024 01:21:07 GMT

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.

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

Marcel_Graumans — Thu, 18 Apr 2024 06:42:14 GMT

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

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

Anonymous — Thu, 18 Apr 2024 07:12:46 GMT

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.

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

Marcel_Graumans — Thu, 18 Apr 2024 08:28:50 GMT

nope i get this result sorry its in dutch

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

Marcel_Graumans — Thu, 18 Apr 2024 08:51:26 GMT

i fix it works now

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

Marcel_Graumans — Thu, 18 Apr 2024 10:29:11 GMT

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