Output Columns False Values

Question

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&nbsp;Column AColumn BColumn CColumn Dexpected outputFALSETRUEFALSETRUEColumn A; Comumn CTRUETRUETRUEFALSEColumn DFALSEFALSEFALSEFALSEColumn A; Comumn B; Column C; Comumn D;&nbsp;TRUETRUETRUETRUE&nbsp;

parry2k · Answer

wolfy_ is there alway going to be 4 columns?

wolfy_ · Answer

Hi parry2k,&nbsp;No the number of columns can variate.

parry2k · Answer

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.
&nbsp;
&nbsp;

wolfy_ · Answer

Hi parry2k&nbsp;I wasn't clear about my data and my objective.&nbsp;My data is like:&nbsp;I would like to have "measure" that would give the output&nbsp;&nbsp;For example for the first line it would be some like: CHECK_MR&nbsp;If for example wasFalse; False; Truethe output would be "CHECK_name_MRBTS_s_LNBTS;CHECK_MRIf it isTrue; False; FalseCHECK_MR;CHECK_cPlanedscp&nbsp;&nbsp;Thanks in advance

ashish_mathur · Answer

Hi,
You may download my PBI file from here.
Hope this helps.

Forum Discussion

Output Columns False Values

9 Replies

Related content

DMV Column Output Definitions and Options

Splitting Column values

Fabric Notebook notebookutils.notebook.exit('Output Value') not working

Matching Column Values

Check column for similar values

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