Output Columns False Values

[wolfy_]

Hi,
Is there any function that tell me what are the columns with false values.
For example, I want the output be COLUMN A; COLUMN C for line 1

Column A	Column B	Column C	Column D	expected output
FALSE	TRUE	FALSE	TRUE	Column A; Comumn C
TRUE	TRUE	TRUE	FALSE	Column D
FALSE	FALSE	FALSE	FALSE	Column A; Comumn B; Column C; Comumn D;
TRUE	TRUE	TRUE	TRUE

[v-danhe-msft]

Hi @wolfy_ ,

Based on my research, there is no dax function to get column name, you could refer to others' solutions by using M code in query editor or you could submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[parry2k]

@wolfy_ got it, I think @Ashish_Mathur has solution in place and should get you what you are looking for. Cheers!!

[wolfy_]

Hi,

I was trying to implement and noticed that the table is created as a DAX expression.

@parry2k @Ashish_Mathur is a solution for this?

[Ashish_Mathur]

Hi,

Mine is an M code.  So if you original table is a Table created via DAX, then my solution will not work.

[parry2k]

@wolfy_ is there alway going to be 4 columns?

[wolfy_]

Hi @parry2k,

No the number of columns can variate.

[parry2k]

@wolfy_ sounds good. solution attached. Most of the work is done in power query to transform the table and then a measure take cares of concatenating the columns.

[wolfy_]

Hi @parry2k I wasn't clear about my data and my objective.

My data is like:

I would like to have "measure" that would give the output

For example for the first line it would be some like: CHECK_MR

If for example was
False; False; True

the output would be "CHECK_name_MRBTS_s_LNBTS;CHECK_MR

If it is

True; False; False

CHECK_MR;CHECK_cPlanedscp

Thanks in advance