Forum Discussion

MichaelSt's avatar
MichaelSt
Frequent Visitor
5 years ago
Solved

Remove Empty Colums

Hi community, I have an tabe that has the following format: Based on a slider on a dropdown on Formname, The records of the table are filtered.  Formname | SubmissionDate | FirstName | Lastnam...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi MichaelSt ,

    You could try the following steps：

    Step1: create a measure like below:

    Measure = 
IF (
    MAX ( 'Table'[SubmissionDate ] ) = BLANK ()
        || MAX ( 'Table'[FirstName] ) = BLANK ()
        || MAX ( 'Table'[FirstName] ) = BLANK ()
        || MAX ( 'Table'[Lastname] ) = BLANK ()
        || MAX ( 'Table'[Email] ) = BLANK ()
        || MAX ( 'Table'[City] ) = BLANK ()
        || MAX ( 'Table'[Address] ) = BLANK (),
    BLANK (),
    1
)

    Step 2: configure the filters:

     

    base data:

     

    and final：

     

     

    Wish it is helpful for you!

    Best Regards

    Lucien

     

v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

Hi MichaelSt ,

You could try the following steps：

Step1: create a measure like below:

Measure = 
IF (
    MAX ( 'Table'[SubmissionDate ] ) = BLANK ()
        || MAX ( 'Table'[FirstName] ) = BLANK ()
        || MAX ( 'Table'[FirstName] ) = BLANK ()
        || MAX ( 'Table'[Lastname] ) = BLANK ()
        || MAX ( 'Table'[Email] ) = BLANK ()
        || MAX ( 'Table'[City] ) = BLANK ()
        || MAX ( 'Table'[Address] ) = BLANK (),
    BLANK (),
    1
)

Step 2: configure the filters:

 

base data:

 

and final：

 

 

Wish it is helpful for you!

Best Regards

Lucien