Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Ignore/remove blanks from this calculated table

Hi,

This have came up in some post I saw, but the ignore funciton didn't work for me.

Any idea how to elimante blanks from below?

 

 

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Anonymous,

     

    If I understand you correctly, the formula below should work in your scenario. :smileyhappy:

    test =
FILTER (
    ADDCOLUMNS (
        SUMMARIZECOLUMNS ( 'Committment Table'[Week] ),
        "Total Commitment", 'Committment Table'[commitment % companies]
    ),
    [Week] <> BLANK ()
)

     

    Regards

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    If I understand you correctly, the formula below should work in your scenario. :smileyhappy:

    test =
FILTER (
    ADDCOLUMNS (
        SUMMARIZECOLUMNS ( 'Committment Table'[Week] ),
        "Total Commitment", 'Committment Table'[commitment % companies]
    ),
    [Week] <> BLANK ()
)

     

    Regards