Forum Discussion

wolfy_'s avatar
wolfy_
Helper I
7 years ago

Output Columns False Values

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 expecte...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

wolfy_ is there alway going to be 4 columns?

  • wolfy_'s avatar
    wolfy_
    Helper I
    7 years ago

    Hi parry2k,

     

    No the number of columns can variate.

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      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_'s avatar
        wolfy_
        Helper I
        7 years ago

        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