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

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