Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summarize DAX

Hi,   Need help.!   I want to summarize without coloums have no date. anyone know how to do?   cheers, Agnes
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Based on my test, you could refer below formula:

    Finish Actual_Over = SUMMARIZE(CALCULATETABLE('Dp List','DP List'[Finish Actual]<>BLANK()), 'DP List' [finish Actual], "DP List Finish Actual#", COUNT('DP List'[D/P&BOM]))

    Result:

    Hope it could help you.

     

    Regards,

    Daniel He