Forum Discussion

shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
9 years ago
Solved

Eliminating null or duplicate rows in a table calculated from summarize function

I created a table to get the distinct irst date of the month and the Max Service Date (from the data load) from  TrendCalcs = SUMMARIZE(Dates,Dates[FirstDateC],Dates[MaxPerMonth]) and I added a colu...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi shelbsassy

     

    You could try something like this?

     

    TrendCalcs = SUMMARIZE(
        FILTER(
            Dates,
            'Dates'[FirstDateC]<> BLANK()
            ),
            'Dates'[FirstDateC],
            Dates[MaxPerMonth]
            )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Had the same issue in a similar context.

 

Approvers = CALCULATETABLE(ALLNOBLANKROW(Persons[Name];Persons[ID]))

 

seems to work in removing blank rows